select prod_id, code, prod_name, prod_desc, thumbnail_image, large_image from products where sr_no > 0 and subcat_id = '22' and maincat_id = '3' limit 6, 27;487;;488;;489;;490;;491;;492;;493;;494;;495;;496;;497;;498;;499;;500;;501;;502;;503;;504;;505;;506;;507;