Anonymous

SELECT
`jos_eventlist_categories`.`id` AS `catID`,
`jos_eventlist_categories`.`catname` AS `catName`,
Count(`jos_eventlist_dates`.`catsid`) AS `numEvents`
FROM
`jos_eventlist_categories`
Left Join `jos_eventlist_dates` ON `jos_eventlist_dates`.`catsid` = `jos_eventlist_categories`.`id` AND
unix_timestamp(`jos_eventlist_dates`.`enddates`) >= '1195974000' AND
`jos_eventlist_dates`.`published` =  '1'
WHERE
`jos_eventlist_categories`.`publishedcat` =  '1'
GROUP BY
`jos_eventlist_dates`.`catsid`,
`jos_eventlist_categories`.`catname`
ORDER BY
`numEvents` DESC,
`jos_eventlist_categories`.`catname` ASC