|

 98B1-5498-2 | 
 98B3-5498blue | 
 98B6Z-5698 |

 MA-5497 | 
 98B6-5698 | 
 98B3-5498red |
|
select prod_id, code, prod_name, prod_desc, thumbnail_image, large_image from products where sr_no > 0 and subcat_id = '13' and maincat_id = '4' limit 6, 34;200; ;201; ;202; ;203; ;204; ;205; ;206; ;207; ;208; ;209; ;210; ;211; ;212; ;213; ;214; ;215; ;216; ;217; ;218; ;219; ;220; ;221; ;222; ;223; ;224; ;225; ;226; ;227; |