IF(pl.name <> '', pl.name, plt.name) AS pname, IF(pl.name2 <> '', pl.name2, plt.name2) AS pname2, IFNULL(`pl`.`shortdesc`, `plt`.`shortdesc`) AS `shortdesc`, m.name AS manuname, `m`.`idm` AS `idm`, `v`.`code`, `v`.`code2`, `v`.`ean`, `v`.`status`, `pl2`.`idpl` AS `idpl`, `pl2`.`price` AS `price`, IF ( (`pl2`.`price` - `pl2`.`oldprice`) > 0, 0, 1) AS `discount`, `pl2`.`oldprice`, `pl2`.`discountpct`, `pl2`.`obratkovostpct`, `pl2`.`changetime`, `pl2`.`minprice30`, `pl2`.`additionalprice`, v.idp, price_level.vat AS vat, pt.type, pt.upscode, pt.dodani, pt.descformat, pt.idt AS idt, p.idau AS idau, author.name AS authorname, author.url AS authorurl, author.paper AS authorpaper, author.mincommissioneur, p.material AS material, p.marketplace AS marketplace, p.explicit AS explicit, p.idg as idg, p.hasvratka, p.b2b, v.idv AS idv, s2pv.`forsale`, s2pv.`ids`, ( SUM(s2pv.`forsale`) - SUM(ABS(s2pv.`reserved`)) - SUM(s2pv.`notforsale`) ) AS total4sale FROM product p JOIN product_type pt on (pt.idt = p.idt) JOIN product_variant v on (v.idp = p.idp) LEFT JOIN author on (author.idau = p.idau) JOIN manufacturer m ON ( m.idm = p.idm ) LEFT JOIN product2language pl ON ( v.idp = pl.idp ) AND (pl.idl = 'fr') LEFT JOIN product2language plt ON ( v.idp = plt.idp ) AND (plt.idl = 'en') LEFT JOIN price_level2product_variant pl2 ON ( v.idv = pl2.idv ) AND (pl2.idpl = 15) LEFT JOIN price_level ON ( price_level.idpl = pl2.idpl) LEFT JOIN store2product_variant s2pv ON (s2pv.idv=v.idv) WHERE v.idv IN (208004, 163637, 178557) AND (v.`status` = 1 OR v.`status` = 2) GROUP BY v.idp ORDER BY FIELD(`v`.`idv`, 208004, 163637, 178557)