Doprava, logistika Karlovy Vary, Karlovarský kraj

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (141,142,1985,143,155,156,160,161,171,162,2620,2767,2768) OR categories LIKE '%,141,%' OR (categories LIKE '%,141,%' OR categories LIKE '%,142,%' OR categories LIKE '%,1985,%' OR categories LIKE '%,143,%' OR categories LIKE '%,155,%' OR categories LIKE '%,156,%' OR categories LIKE '%,160,%' OR categories LIKE '%,161,%' OR categories LIKE '%,171,%' OR categories LIKE '%,162,%' OR categories LIKE '%,2620,%' OR categories LIKE '%,2767,%' OR categories LIKE '%,2768,%')) AND admin_lock=0 AND deleted<>1 AND host='karlovarsko') AS Results WHERE RowNum BETWEEN 1696 AND 1710