SELECT * FROM (select site_category.name, count(site_merchant_categories_fr.category_id) as count
from site_merchant_categories_fr, site_category
where site_category.id = site_merchant_categories_fr.category_id
group by site_merchant_categories_fr.category_id
order by count DESC
limit 50) as TOP_50 ORDER BY site_category.name ASC;