Cacher is the code snippet organizer for pro developers

-- ORDER BY (SELECT count(d.sad_id) as c FROM wifcms_mod_scan_sel_ads_fotos as d WHERE d.sad_id = s.sad_id GROUP BY d.sad_id) DESCLIMIT 50

-- http://stackoverflow.com/questions/813495/mysql-order-by-select-possible