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 (171332) 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:
Rockoff Retial Limited
GB07770109
www.rockofftrade.com
Units 1, 2 & 3 Aintree Building, Aintree Way, Liverpool, England, L9 5Aq
sales@rockofftrade.com
Europosters, S. R. O.
CZ05040418
https://www.europosters.eu/
Hlavní 365, 25207 Štěchovice, Czech Republic
info@europosters.eu
GTIN-13 / EAN:
5055979951995