SELECT `translations`.* FROM `translations` WHERE (projekt = '7') AND (name = 'pop-up-redirect') AND (lang = 2)
SELECT * FROM `category` AS `c` JOIN `category2language` AS `c2l` ON (`c2l`.`idc` = `c`.`idc`) AND (`c2l`.`idl` = ?) WHERE c.idc = ?
SELECT idc, tag2category.tag, tag2category.flag, tag.translate, tag.ignore, name FROM tag2category
LEFT JOIN tag on (tag.tag = tag2category.tag)
LEFT JOIN tag2language on (tag2category.tag = tag2language.tag) and (idl = ?)
WHERE idc = ?
SELECT 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,
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 = '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) JOIN store2product_variant s2pv ON (s2pv.idv=v.idv) JOIN product2category_cache ov ON (v.idp = ov.idp) AND (ov.idc = '1594') 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
SELECT FOUND_ROWS()
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 95049
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 52543
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 86310
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146876
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 161434
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 160578
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146888
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146887
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146886
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146885
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146884
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146883
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146882
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146881
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146880
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146879
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146878
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146877
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146875
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 146874
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 143921
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 143918
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 143753
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 139943
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 114011
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 99770
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 97207
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 83174
SELECT SQL_NO_CACHE * FROM `store2product_variant` WHERE `idv` = 77265
(SELECT IFNULL(`a2p`.`ida`, `a2pt`.`ida`) AS `ida`, IFNULL(`a2p`.`value`, `a2pt`.`value`) AS `value`, 0 AS `variable`, `v`.`idv`
FROM `product_variant` AS `v`
LEFT JOIN `attribute2product` AS `a2p` ON (`a2p`.`idp` = `v`.`idp`) AND (`a2p`.`idl` = 'cz')
LEFT JOIN `attribute2product` AS `a2pt` ON (`a2pt`.`idp` = `v`.`idp`) AND (`a2pt`.`idl` = 'en')
WHERE `v`.`idv` IN (95049, 52543, 86310, 146876, 161434, 160578, 146888, 146887, 146886, 146885, 146884, 146883, 146882, 146881, 146880, 146879, 146878, 146877, 146875, 146874, 143921, 143918, 143753, 139943, 114011, 99770, 97207, 83174, 77265)) UNION (SELECT IFNULL(`a2v`.`ida`, `a2vt`.`ida`) AS `ida`, IFNULL(`a2v`.`value`, `a2vt`.`value`) AS `value`, 1 AS `variable`, `v`.`idv`
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` IN (95049, 52543, 86310, 146876, 161434, 160578, 146888, 146887, 146886, 146885, 146884, 146883, 146882, 146881, 146880, 146879, 146878, 146877, 146875, 146874, 143921, 143918, 143753, 139943, 114011, 99770, 97207, 83174, 77265))
SELECT `i`.`idi`, `name`, `origname`, `default`, `format`, `type`, `i`.`status`, `i`.`gcloud`, 0 AS `variable`, `idv`
FROM image i
JOIN image2product on (i.idi = image2product.idi)
JOIN product_variant pv ON (pv.idp = image2product.idp)
WHERE `idv` IN (95049, 52543, 86310, 146876, 161434, 160578, 146888, 146887, 146886, 146885, 146884, 146883, 146882, 146881, 146880, 146879, 146878, 146877, 146875, 146874, 143921, 143918, 143753, 139943, 114011, 99770, 97207, 83174, 77265)
SELECT
pv.idv, pv.idp, price_level.vat AS vat,
IFNULL(`a2v`.`ida`, `a2vt`.`ida`) AS `ida`,
IFNULL(`a2v`.`value`, `a2vt`.`value`) AS `value`,
1 AS `variable`,
`pl2pv`.`idpl`, `pl2pv`.`price`, `pl2pv`.`oldprice`, `pl2pv`.`discountpct`, `pl2pv`.`obratkovostpct`, `pl2pv`.`changetime`, `pl2pv`.`changesource`, `pl2pv`.`minprice30`, `pl2pv`.`additionalprice`
FROM product_variant pv
JOIN price_level2product_variant pl2pv ON (pl2pv.idv = pv.idv) AND (pl2pv.idpl = 3) AND (pl2pv.price > 0)
JOIN price_level ON (price_level.idpl = pl2pv.idpl)
LEFT JOIN `attribute2product_variant` AS `a2v` ON (`a2v`.`idv` = `pv`.`idv`) AND (`a2v`.`idl` = 'cz')
LEFT JOIN `attribute2product_variant` AS `a2vt` ON (`a2vt`.`idv` = `pv`.`idv`) AND (`a2vt`.`idl` = 'en')JOIN store2product_variant s2pv ON (s2pv.idv = pv.idv) AND (s2pv.forsale - s2pv.reserved > 0 )
WHERE pv.idp IN (72678, 35337, 64581, 121481, 135691, 134835, 121493, 121492, 121491, 121490, 121489, 121488, 121487, 121486, 121485, 121484, 121483, 121482, 121480, 121479, 118530, 118527, 118362, 114783, 89681, 77408, 74838, 61532, 56148) AND pv.status = 1
ORDER BY pl2pv.price ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '72678' ORDER BY `default` ASC
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 `idc`, `default` FROM `product2category` WHERE `idp` = '35337' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '64581' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121481' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '135691' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '134835' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121493' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121492' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121491' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121490' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121489' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121488' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121487' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121486' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121485' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121484' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121483' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121482' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121480' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '121479' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '118530' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '118527' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '118362' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '114783' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '89681' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '77408' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '74838' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '61532' ORDER BY `default` ASC
SELECT `idc`, `default` FROM `product2category` WHERE `idp` = '56148' ORDER BY `default` ASC
SELECT fid FROM fotolia2category WHERE idc IN (1594)
SELECT fid, name FROM fotolia2language WHERE fid IN (69824143, 117524744, 124494207, 135022410, 100990935, 109699950, 95216941, 100434574, 163814679, 78786461, 69313102, 140754658, 60452932, 42235540, 129194250, 127769559, 137041234, 153613252, 69824148) AND idl = ?
SELECT * FROM `category` AS `c` JOIN `category2language` AS `c2l` ON (`c2l`.`idc` = `c`.`idc`) AND (`c2l`.`idl` = ?) WHERE c.idc = ?
SELECT url, name, idl FROM category2language WHERE idc = ?
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ů..