SQL_CALC_FOUND_ROWS 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 , `ov`.`score` AS score 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 = 'sk') 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 = 5) LEFT JOIN price_level ON ( price_level.idpl = pl2.idpl) JOIN store2product_variant s2pv ON (s2pv.idv=v.idv) JOIN product2category_cache ov ON (v.idp = ov.idp) AND (ov.idc = '3808') WHERE (( (s2pv.`forsale` - s2pv.`reserved` - s2pv.`notforsale`) > 0) OR v.`status` = 2) AND (v.`status` = 1 OR v.`status` = 2) GROUP BY v.idp ORDER BY score DESC LIMIT 0, 48