mathieuc

SELECT * FROM (select site_category.name, count(site_merchant_categories_fr.category_id) as countfrom site_merchant_categories_fr, site_categorywhere site_category.id = site_merchant_categories_fr.category_idgroup by site_merchant_categories_fr.category_idorder by count DESClimit 50) as TOP_50 ORDER BY site_category.name ASC;