Sql

SELECT tt1.term, tt1.level_name,COUNT(tt1.level_name) AS c
FROM tezaver_taxonomy tt
JOIN tezaver_taxonomy tt1 ON tt.`id_tezaver` = tt1.id_tezaver AND tt.`level` = tt1.`level` -1 
where tt.term = 'animalia'
GROUP BY tt1.term,tt1.level_name

če se skoncentriramo na Arthropoda in max cifra pomeni, da mi je ta record najbolj všeč, kako dobim samo te KOMPLET recorde z max cifro, za vsak term ?

Če zavijem v tole, dobim max cifro, ne dobim pa 'phylum' kar bi rad, ampak ''.

SELECT term,level_name, MAX(c) FROM
(
SELECT tt1.term, tt1.level_name,COUNT(tt1.level_name) AS c
FROM tezaver_taxonomy tt
JOIN tezaver_taxonomy tt1 ON tt.`id_tezaver` = tt1.id_tezaver AND tt.`level` = tt1.`level` -1 
where tt.term = 'animalia'
GROUP BY tt1.term,tt1.level_name
) AS c
GROUP BY term