SQL_CALC_FOUND_ROWS pl.name AS pname, pl.name2 AS pname2, pl.keyword AS keyword, 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_variant v JOIN product p ON (p.idp = v.idp) JOIN product_type pt on (pt.idt = p.idt) 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 = 'cz') LEFT JOIN price_level2product_variant pl2 ON ( v.idv = pl2.idv ) AND (pl2.idpl = 21) LEFT JOIN price_level ON ( price_level.idpl = pl2.idpl) JOIN store2product_variant s2pv ON (s2pv.idv=v.idv) WHERE p.idp IN (116442) AND (( (s2pv.`forsale` - s2pv.`reserved` - s2pv.`notforsale`) > 0) OR v.`status` = 2) AND (v.`status` = 1 OR v.`status` = 2) GROUP BY v.idv ORDER BY `price` IS NOT NULL DESC, `price` > 1 DESC, (price * (1 - (GREATEST(discountpct, obratkovostpct) / 100))) ASC
Fabrikant:
Difuzed B.V.
NL804403375B01
www.difuzed.com/shop
Molenwerf 24, 1911 Db Uitgeest I, Netherlands
info@difuzed.com
GTIN-13 / EAN:
8718526146790