select prod_id, code, prod_name, prod_desc, thumbnail_image, large_image from products where sr_no > 0 and subcat_id = '14' and maincat_id = '4' limit 6, 7;284;