SELECT `productid`, `product`, `productslug`, `price`, `list_price`, `sizes`, `mainimage` FROM `ml_pro` WHERE `tavail` >0 AND `avail` >0 AND `isactive` = 1 AND productid IN (SELECT pro_id FROM ml_procat WHERE cat_id=1284) ORDER BY `points` desc, `add_date` desc LIMIT 40, 40 Lacoste | Streetwear, Skate Clothing, Footwear, Accessories - MLTD
  • cart 0