Rozbudowanie zapytania o COUNT() Opcje

[miedzna]

Mam takie zapytanie:

[SQL] pobierz, plaintext 
SELECT i.imageid, i.categoryid, i.username, i.path, i.filename, i.title, i.viewcount, i.comcount, i.downloadcount, i.created, c.title AS categorytitle
FROM _images i
LEFT JOIN _categories c ON ( c.categoryid = i.categoryid ) 
WHERE (
i.usergroupids = 'all'
OR i.usergroupids LIKE '%(1)%'
)
AND i.actived =1
AND c.actived =1
ORDER BY i.ordernum DESC 
LIMIT 0 , 10 
[SQL] pobierz, plaintext 

Chcę dorzucić jeszcze coś w stylu COUNT( x.commentid ) AS ileKomentarzy i zapytanie zmienia sie na:

[SQL] pobierz, plaintext 
SELECT COUNT( x.commentid ) AS ileKomentarzy, i.imageid, i.categoryid, i.username, i.path, i.filename, i.title, i.viewcount, i.comcount, i.downloadcount, i.created, c.title AS categorytitle
FROM _images i, _comments x
LEFT JOIN _categories c ON ( c.categoryid = i.categoryid ) 
WHERE (
 
i.usergroupids =  'all'
OR i.usergroupids LIKE  '%(1)%'
)
AND i.actived =1
AND c.actived =1
ORDER BY i.ordernum DESC 
LIMIT 0 , 10
[SQL] pobierz, plaintext 

ale wywala błąd: #1054 - Nieznana kolumna 'i.categoryid' w on clause.

[yevaud]

zamiast
FROM _images i, _comments x
daj
FROM _comments x, _images i