Automobily, motocykly Praha, Praha a Středočeský kraj

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (4,21,2204,27,29,31,36,33,35,42,40,41,43,2550,51,53,2723,2758,2759,2760,3,2258,5,6,7,8,12,14,16,17,44,2004) OR categories LIKE '%,4,%' OR (categories LIKE '%,4,%' OR categories LIKE '%,21,%' OR categories LIKE '%,2204,%' OR categories LIKE '%,27,%' OR categories LIKE '%,29,%' OR categories LIKE '%,31,%' OR categories LIKE '%,36,%' OR categories LIKE '%,33,%' OR categories LIKE '%,35,%' OR categories LIKE '%,42,%' OR categories LIKE '%,40,%' OR categories LIKE '%,41,%' OR categories LIKE '%,43,%' OR categories LIKE '%,2550,%' OR categories LIKE '%,51,%' OR categories LIKE '%,53,%' OR categories LIKE '%,2723,%' OR categories LIKE '%,2758,%' OR categories LIKE '%,2759,%' OR categories LIKE '%,2760,%' OR categories LIKE '%,3,%' OR categories LIKE '%,2258,%' OR categories LIKE '%,5,%' OR categories LIKE '%,6,%' OR categories LIKE '%,7,%' OR categories LIKE '%,8,%' OR categories LIKE '%,12,%' OR categories LIKE '%,14,%' OR categories LIKE '%,16,%' OR categories LIKE '%,17,%' OR categories LIKE '%,44,%' OR categories LIKE '%,2004,%')) AND admin_lock=0 AND deleted<>1 AND host='praha') AS Results WHERE RowNum BETWEEN 1396 AND 1410