SELECT GROUP_CONCAT(DISTINCT provar.sizename ORDER BY provar.sizename) as sizes, GROUP_CONCAT(DISTINCT provar.colorname ORDER BY provar.colorname) as colors, GROUP_CONCAT(DISTINCT ml_pro.brandid ORDER BY ml_pro.brandid) as brands, GROUP_CONCAT(DISTINCT ml_pro.product_type ORDER BY ml_pro.product_type) as product_types, GROUP_CONCAT(DISTINCT ml_pro.product_type2 ORDER BY ml_pro.product_type2) as product_types2, max(ml_pro.price) as maxprice, min(ml_pro.price) as minprice FROM `ml_pro` LEFT JOIN `provar` ON `ml_pro`.`productid`=`provar`.`productid` LEFT JOIN `ml_procat` ON `ml_pro`.`productid`=`ml_procat`.`pro_id` WHERE `ml_procat`.`cat_id` = '488' AND `provar`.`quantity` >0 AND `ml_pro`.`isactive` = 1
Women's | Streetwear, Skate Clothing, Footwear, Accessories - MLTD
  • 0