Poradenství Zlín, Zlínský kraj

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (119,122,123,2163,125,128,131,2701,2054) OR categories LIKE '%,119,%' OR (categories LIKE '%,119,%' OR categories LIKE '%,122,%' OR categories LIKE '%,123,%' OR categories LIKE '%,2163,%' OR categories LIKE '%,125,%' OR categories LIKE '%,128,%' OR categories LIKE '%,131,%' OR categories LIKE '%,2701,%' OR categories LIKE '%,2054,%')) AND admin_lock=0 AND deleted<>1 AND host='zlinsko') AS Results WHERE RowNum BETWEEN 286 AND 300