Cestování, 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 (54,55,60,65,66,2096,2448,69,70,71,72,73,2447,68) OR categories LIKE '%,54,%' OR (categories LIKE '%,54,%' OR categories LIKE '%,55,%' OR categories LIKE '%,60,%' OR categories LIKE '%,65,%' 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 931 AND 945