Zdravotnická zařízení Brno, Jihomoravský kraj

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (1951,1952,1953,1954,1955,1956,2236,2110,1957) OR categories LIKE '%,1951,%' OR (categories LIKE '%,1951,%' OR categories LIKE '%,1952,%' OR categories LIKE '%,1953,%' OR categories LIKE '%,1954,%' OR categories LIKE '%,1955,%' OR categories LIKE '%,1956,%' OR categories LIKE '%,2236,%' OR categories LIKE '%,2110,%' OR categories LIKE '%,1957,%')) AND admin_lock=0 AND deleted<>1 AND host='brnensko') AS Results WHERE RowNum BETWEEN 1546 AND 1560