Sport 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 (1848,1863,2775,1860,1867,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2790,2791,2788,2789,2799) OR categories LIKE '%,1848,%' OR (categories LIKE '%,1848,%' OR categories LIKE '%,1863,%' OR categories LIKE '%,2775,%' OR categories LIKE '%,1860,%' OR categories LIKE '%,1867,%' OR categories LIKE '%,2776,%' OR categories LIKE '%,2777,%' OR categories LIKE '%,2778,%' OR categories LIKE '%,2779,%' OR categories LIKE '%,2780,%' OR categories LIKE '%,2781,%' OR categories LIKE '%,2782,%' OR categories LIKE '%,2783,%' OR categories LIKE '%,2784,%' OR categories LIKE '%,2785,%' OR categories LIKE '%,2786,%' OR categories LIKE '%,2787,%' OR categories LIKE '%,2790,%' OR categories LIKE '%,2791,%' OR categories LIKE '%,2788,%' OR categories LIKE '%,2789,%' OR categories LIKE '%,2799,%')) AND admin_lock=0 AND deleted<>1 AND host='praha') AS Results WHERE RowNum BETWEEN 2506 AND 2520