Úřady a ústavy, svazy 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 (1536,2229,1537,2044,1538,1541,1543,2228,2238,2242,2244,2241,2243,2245,2240,2239,2227,1546,2230,1547,1548,2691,1549,1550,1551,1552,1553,1555,1556,2173,1561,2149,2157,2727,2138,2797) OR categories LIKE '%,1536,%' OR (categories LIKE '%,1536,%' OR categories LIKE '%,2229,%' OR categories LIKE '%,1537,%' OR categories LIKE '%,2044,%' OR categories LIKE '%,1538,%' OR categories LIKE '%,1541,%' OR categories LIKE '%,1543,%' OR categories LIKE '%,2228,%' OR categories LIKE '%,2238,%' OR categories LIKE '%,2242,%' OR categories LIKE '%,2244,%' OR categories LIKE '%,2241,%' OR categories LIKE '%,2243,%' OR categories LIKE '%,2245,%' OR categories LIKE '%,2240,%' OR categories LIKE '%,2239,%' OR categories LIKE '%,2227,%' OR categories LIKE '%,1546,%' OR categories LIKE '%,2230,%' OR categories LIKE '%,1547,%' OR categories LIKE '%,1548,%' OR categories LIKE '%,2691,%' OR categories LIKE '%,1549,%' OR categories LIKE '%,1550,%' OR categories LIKE '%,1551,%' OR categories LIKE '%,1552,%' OR categories LIKE '%,1553,%' OR categories LIKE '%,1555,%' OR categories LIKE '%,1556,%' OR categories LIKE '%,2173,%' OR categories LIKE '%,1561,%' OR categories LIKE '%,2149,%' OR categories LIKE '%,2157,%' OR categories LIKE '%,2727,%' OR categories LIKE '%,2138,%' OR categories LIKE '%,2797,%')) AND admin_lock=0 AND deleted<>1 AND host='praha') AS Results WHERE RowNum BETWEEN 916 AND 930