SET character_set_results=utf8, character_set_connection=utf8, character_set_client=utf8;
SELECT 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`,
IF(`pl`.`longdesc` <> '', `pl`.`longdesc`, `plt`.`longdesc`) AS `longdesc`, 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,
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 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 = 3) LEFT JOIN price_level ON ( price_level.idpl = pl2.idpl) LEFT JOIN store2product_variant s2pv ON (s2pv.idv=v.idv) WHERE v.idv IN (63505) GROUP BY v.idv ORDER BY v.`idv` DESC LIMIT 1
SELECT `pl2`.*, `pl`.`vat` AS `vat` FROM `price_level2product_variant` AS `pl2`
JOIN `price_level` AS `pl` ON (`pl`.`idpl` = `pl2`.`idpl`)
JOIN `product_variant` AS `v` ON (`v`.`idv` = `pl2`.`idv`)
JOIN `product` AS `p` ON (`p`.`idp` = `v`.`idp`)
JOIN `product_type` AS `pt` ON (`pt`.`idt` = `p`.`idt`)
WHERE `pl2`.`idv` = 63505
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 63505
(SELECT IFNULL(`a2p`.`ida`, `a2pt`.`ida`) AS `ida`, IFNULL(`a2p`.`value`, `a2pt`.`value`) AS `value`, 0 AS `variable`
FROM `product` AS `p`
LEFT JOIN `attribute2product` AS `a2p` ON (`a2p`.`idp` = `p`.`idp`) AND (`a2p`.`idl` = 'cz')
LEFT JOIN `attribute2product` AS `a2pt` ON (`a2pt`.`idp` = `p`.`idp`) AND (`a2pt`.`idl` = 'en')
WHERE `p`.`idp` = 43344) UNION (SELECT IFNULL(`a2v`.`ida`, `a2vt`.`ida`) AS `ida`, IFNULL(`a2v`.`value`, `a2vt`.`value`) AS `value`, 1 AS `variable`
FROM `product_variant` AS `v`
LEFT JOIN `attribute2product_variant` AS `a2v` ON (`a2v`.`idv` = `v`.`idv`) AND (`a2v`.`idl` = 'cz')
LEFT JOIN `attribute2product_variant` AS `a2vt` ON (`a2vt`.`idv` = `v`.`idv`) AND (`a2vt`.`idl` = 'en')
WHERE `v`.`idv` = 63505)
(SELECT `i`.`idi`, `name`, `origname`, `default`, `format`, `type`, `status`, `i`.`gcloud`, 0 AS `variable` FROM `image2product` i2p JOIN image i ON (i.idi = i2p.idi) WHERE `idp` = 43344 ORDER BY `default` ASC) UNION (SELECT `i`.`idi`, `name`, `origname`, `default`, `format`, `type`, `status`, `i`.`gcloud`, 1 AS `variable` FROM `image2product_variant` i2pv JOIN image i ON (i.idi = i2pv.idi) WHERE `idv` = 63505 ORDER BY `default` ASC) ORDER BY `default` ASC
SELECT `idfi` FROM `file2product` WHERE `idp` = 43344 ORDER by `order` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '43344' ORDER BY `default` ASC
SELECT ida,poradi,variabil FROM attribute2product_type WHERE idt = 'pod-ilustrace' ORDER BY poradi
SELECT * FROM product2language WHERE idp = ?
SELECT * FROM attribute2product WHERE idp = ?
SELECT * FROM attribute2product_variant WHERE idv = ?
SELECT * FROM tag2product WHERE idp = ?
SELECT sold FROM ordered_variant_cache WHERE idp = ?
SELECT sold FROM ordered_variant_cache_total WHERE idp = ?
SELECT * FROM product2language WHERE idp = ?
SELECT idv FROM product_variant WHERE idp = ?
SELECT `ida`, `value`, 0 AS `variable`
FROM `product` AS `p`
LEFT JOIN `attribute2product` AS `a2p` ON (`a2p`.`idp` = `p`.`idp`) AND (`a2p`.`idl` = 'en')
WHERE `p`.`idp` = 43344
SELECT `i`.*, `m`.* FROM `lang_to_projekt` AS `i`
INNER JOIN `translations` AS `m` ON `i`.`lang` = `m`.`lang` WHERE (m.projekt = '7') AND (m.lang = '1') AND (`i`.`projekt` = 7)
SELECT `translations`.* FROM `translations` WHERE (projekt = '7') AND (name = 'pop-up-redirect') AND (lang = 2)
SELECT `d`.*, `dp`.`idpa` FROM `eshop2delivery` AS `d`
LEFT JOIN `delivery2pay` AS `dp` USING(`ide`,`idd`,`country`)
LEFT JOIN eshop2pay USING (ide, idpa) WHERE ide = 5 ORDER BY d.poradi ASC, eshop2pay.poradi ASC
SELECT * FROM review2product WHERE idt LIKE ? AND rating >= 3 AND status > 0 AND idl = 'cz' AND LENGTH(text) > '10' GROUP BY idr ORDER by idp = ? DESC, idf = ? DESC, featured DESC, rating DESC, time DESC LIMIT 7
Barvy výsledného tisku nemusí vždy zcela odpovídat barvám na vaší obrazovce.
EUROPOSTERS, s. r. o.
PO–PÁ 7:00–17:00
+420 210 440 210
S Posters.cz jsme na trhu již od roku 1999 a postupně jsme se stali jedním z největších prodejců plakátů, obrazů a licencovaných merchandise dárků v Česku i v celé Evropě. Máme skladem ohromnou nabídku filmových, herních či sportovních plakátů všech velikostí i plný sklad originálních dárků pro zaryté fanoušky Star Wars, Harryho Pottera, komiksů či celé rodiny Warner Bros. Hrnky, figurky, puzzle i oblečení jsou totiž tím nejlepším dárkem pro všechny bez rozdílu věku či zájmů. Jestli jsi ale fanda spíš interiérového designu, tak i pak jsi tu správně! Máme vlastní tiskárny a tak fototapety, ilustrace, fotografie či umělecké reprodukce tiskneme jak na běžícím páse a dennodenně posíláme do více než 25 zemí.
© 1999–2024 Europosters, s. r. o. Všechna práva vyhrazena.
Přihlášením souhlasíte s našimi zásadami ochrany osobních údajů..