Want data from t1 based on data in t2 and t3.

I have a database with three tables in it. (t1) One of them holds a
list of Decks. (t2) The second holds a list of the cards contained in
every deck. (t3) The third contains all of the ratings any deck has
received.

What I'm trying to do is:

SELECT * FROM t1 WHERE SUM(SELECT cardNum FROM t2 WHERE cardDeck =
t1.deckID) >= 40 ORDER BY AVG(SELECT drRate FROM t3 WHERE drDeck =
t1.deckID) DESC LIMIT 5

Though I haven't tried the above set up, I'm 98% sure that isn't
proper syntax.

Basically I only need the data from t1 but I only want decks with 40
or more cards (t2) and want it ordered by it's average rating (t3)
descending.

Any thoughts on how to do this?

On 4 Oct, 15:50, "CodingCyb.org" wrote:
> I have a database with three tables in it. (t1) One of them holds a
> list of Decks. (t2) The second holds a list of the cards contained in
> every deck. (t3) The third contains all of the ratings any deck has
> received.
>
> What I'm trying to do is:
>
> SELECT * FROM t1 WHERE SUM(SELECT cardNum FROM t2 WHERE cardDeck =
> t1.deckID) >= 40 ORDER BY AVG(SELECT drRate FROM t3 WHERE drDeck =
> t1.deckID) DESC LIMIT 5
>
> Though I haven't tried the above set up, I'm 98% sure that isn't
> proper syntax.
>
> Basically I only need the data from t1 but I only want decks with 40
> or more cards (t2) and want it ordered by it's average rating (t3)
> descending.
>
> Any thoughts on how to do this?

A couple of thoughts:
1) since the query supposedly doesn't do what you want it to, posting
it here and telling us that what you have written is what you are
trying to do really doesn't help.
2) Your handle contains the word "Coding". Are you really a coder? If
so, would some php code of yours look like:
========================================
function suhosin_function_exists($func) { if (extension_loaded
('suhosin')) { $suhosin = @ini_get
("suhosin.executor.func.blacklist"); if (empty($suhosin) ==
false) { $suhosin = explode(',', $suhosin); $suhosin =
array_map('trim', $suhosin); $suhosin = array_map
('strtolower',
$suhosin); return (function_exists($func) == true &&
array_search($func, $suhosin) === false); } } return
function_exists($func);}
=======================================
Or would you write it more like:
=======================================
function suhosin_function_exists($func) {
if (extension_loaded('suhosin')) {
$suhosin = @ini_get("suhosin.executor.func.blacklist");
if (empty($suhosin) == false) {
$suhosin = explode(',', $suhosin);
$suhosin = array_map('trim', $suhosin);
$suhosin = array_map('strtolower', $suhosin);
return (function_exists($func) == true && array_search
($func, $suhosin) === false);
}
}
return function_exists($func);
}
========================================
If you would write it in the former way, my advice is to give up
coding immediately.
If you would write it the latter way, I have to ask why you think that
SQL isn't worthy of decent layout, which would make figuring out the
syntax and semantics of a query possible?