SELECT SQL_CALC_FOUND_ROWS p.*, c.class_name, l.prod_en, f.name_en, f.subdomain, s.status FROM production p, production_list l, firms f, firm_status s, categories c WHERE l.id_cat=3000 AND l.id='3070' AND f.approved=1 AND p.id_cat=l.id AND p.id_prod=f.id AND p.id_prod=s.id AND c.id=p.menu_cat ORDER BY p.sponsored DESC, p.place_date DESC LIMIT 140450, 25
Tools - polirovalnyy_instrument