>>select products.id from products left join colorsNsizes on products.id=colorsNsizes.productID where colorsNsizes.available=1 and products.outOfStock=0 and categoriesMRLN!="" and (CONCAT(",", categoriesMRLN, ",") REGEXP ",(367|582|453|452|451|455|457|456|458|454),") and (products.price*(100-colorsNsizes.discount)/100>=0 and products.price*(100-colorsNsizes.discount)/100<=100000) and (colorsNsizes.size>0 and colorsNsizes.available=1) group by colorsNsizes.productID, colorsNsizes.color