SELECT * FROM tbl_product JOIN tbl_productcolor ON vch_productId = vch_productcolorProduct JOIN tbl_subcategory2 ON vch_productSubcategory2 = vch_subcat2Id JOIN tbl_productcolorsize ON vch_productcolorsizeColor=vch_productcolorId WHERE vch_subcat2Slug = 'slimming-products' and int_productcolorsizeStock >0 GROUP BY vch_productId ASC ORDER BY dat_productcolorAdded desc LIMIT 0,45