SELECT * FROM vwProducts WHERE 1=1 AND LOWER(ItemEntityId) = LOWER('132877') AND LOWER(ItemApprovedforInc) = LOWER('1') AND LOWER(ItemIsActive) = LOWER('1') AND LOWER(ItemIsSampleOnly) = LOWER('0') GROUP BY SeriesID ORDER BY ItemEntityId ASC LIMIT 0, 1;SELECT * FROM vwProducts WHERE 1=1 GROUP BY SeriesID ORDER BY SeriesName ASC LIMIT 25, 4;
