mysql2: select top 9999 * from (select row_number() over (order by featuredflagorder asc) as RowNumber, * from (select * from products where CatalogId In (2,3,6,7,9,10,11,46,47) ) as d) as queries where (RowNumber <= 9999 AND RowNumber >= 1)