>>select products.id, products.price, products.discount, categoriesMRLN, titleEL, products.qnt, callForPrice, onMenu, availability, kind, alias, crazySale, new_pr, offer, code, old_price, color, allCombs, colorsNsizes.discount, size, postEL, 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='8046' and colorsNsizes.color='3') or (products.id='7768' and colorsNsizes.color='25') or (products.id='6394' and colorsNsizes.color='3') or (products.id='6316' and colorsNsizes.color='21') or (products.id='22488' and colorsNsizes.color='95') or (products.id='19025' and colorsNsizes.color='21') or (products.id='18801' and colorsNsizes.color='6') or (products.id='17695' and colorsNsizes.color='3') or (products.id='13272' and colorsNsizes.color='16') or (products.id='13271' and colorsNsizes.color='21') or (products.id='12713' and colorsNsizes.color='1') or (products.id='12644' and colorsNsizes.color='1'))