Ubytování Budějovice, Jihočeský kraj

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (66,2096,2448,69,70,71,72,73,2447,68) OR categories LIKE '%,66,%' OR (categories LIKE '%,66,%' OR categories LIKE '%,2096,%' OR categories LIKE '%,2448,%' OR categories LIKE '%,69,%' OR categories LIKE '%,70,%' OR categories LIKE '%,71,%' OR categories LIKE '%,72,%' OR categories LIKE '%,73,%' OR categories LIKE '%,2447,%' OR categories LIKE '%,68,%')) AND admin_lock=0 AND deleted<>1 AND host='budejovicko') AS Results WHERE RowNum BETWEEN 136 AND 150