>>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 (CONCAT(",", categoriesMRLN, ",") REGEXP ",(1033),") and (CONCAT(",", categoriesMRLN, ",") REGEXP ",(367|56|139|44|97|166|49|63|366|61|96|93|70|645|637|632|641|643|469|459|466|465|884|813|468|804|968|885|973|974|821|823|824|825|826|842|841|843|844|845|846|848|816|43|829|831|830|834|836|838|833|861|847),")