>>select products.id, products.price, products.discount, categoriesMRLN, titleEN, products.qnt, callForPrice, onMenu, availability, kind, alias, crazySale, new_pr, offer, code, old_price, color, allCombs, colorsNsizes.discount, size, postEN, weight, labels, colorsNsizes.qnt as qntpervariation from products left join colorsNsizes on products.id=colorsNsizes.productID where colorsNsizes.available=1 and products.outOfStock=0 and categoriesMRLN!="" and ((products.id='6585' and colorsNsizes.color='21') or (products.id='6773' and colorsNsizes.color='25') or (products.id='15068' and colorsNsizes.color='21') or (products.id='12607' and colorsNsizes.color='43') or (products.id='9620' and colorsNsizes.color='56') or (products.id='26238' and colorsNsizes.color='21') or (products.id='24829' and colorsNsizes.color='21') or (products.id='26034' and colorsNsizes.color='98') or (products.id='24470' and colorsNsizes.color='15'))