[SQL] Problem z COUNT i WHERE Opcje

[ewelinac18]

Witam mam problem z COUNT i WHERE

[SQL] pobierz, plaintext 
SELECT u.username, u.user_rank, u.user_id, COUNT(t.id_glos) AS bb, u.glos AS srednia
FROM typy AS t
JOIN phpbb_users AS u ON ( u.user_id = t.id_glos )
GROUP BY u.user_id
ORDER BY srednia DESC
[SQL] pobierz, plaintext 

Gdy dodam

[SQL] pobierz, plaintext 
WHERE bb > 5
[SQL] pobierz, plaintext 

Mam problem bo wyskakuje błąd

Kod

#1054 - Unknown column 'bb' in 'where clause'

Macie może pomysł aby jakoś zastosować to WHERE dla COUNT(t.id_glos) AS bb (IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif)

[nospor]

no ewidentnie tabela phpbb_users nie zawiera kolumny glos