Plyšový medvídek Charly s kufrem Číslo zboží: 012938 Barva: béžový Velikost: 30 cm z měkkého plyše Lze prát při 30 stupních. Kufr nelze prát. Chybí či je nepravdivý některý důležitý parametr?
Uvedené informace jsou pouze orientační, před zakoupením ve vybraném obchodě doporučujeme ověřit, že prodávaný model má klíčové vlastnosti dle vašich požadavků. I když se snažíme o maximální přesnost informací, bohužel nemůžeme zaručit jeho 100% správnost. Ceny produktů jsou uváděny včetně DPH.
Dotaz cislo:72
SELECT *
FROM shop_mu
WHERE Id=1 AND
IdLanguage=1
select properties of object CShopMU
Vlastnosti
Název vlastnosti |
Hodnota |
Dotaz cislo:73
SELECT *
FROM shop_search
WHERE Id=3
select properties of object CShopSearch
Dotaz cislo:74
SELECT *
FROM shop_search2lang
WHERE IdSearch = 3 AND
IdLanguage = 1
select properties of object shop_serach2lang
Dotaz cislo:75
SELECT *
FROM shop_search2cat WHERE IdSearch = '3'
ORDER BY colOrder ASC
select properties of object CShopSearch2Cat
wer |
od 5 let |
Položky v sestavě
Dotaz cislo:76
SELECT al.Name, al.ShortName, al.Description, al.Flags as LangFlags, al.SubName, a.*, a2i.IdImage, mu.Value as MUName, vd2l.Name as DirectoryName FROM shop_article a INNER JOIN shop_art2lang al ON al.IdArticle=a.Id AND al.IdLanguage = 1 LEFT JOIN shop_art2img a2i ON a2i.IdArticle=a.Id AND a2i.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.Id) LEFT JOIN shop_mu mu ON mu.Id=a.IdMU AND mu.IdLanguage=1 INNER JOIN virtual_directory vd ON vd.IdSecuritySection = 17 AND vd.IdItem = a.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=1 INNER JOIN shop_cost sc ON sc.IdArticle=a.Id AND sc.IdType=3 AND sc.value>0 INNER JOIN shop_bundle_articles saa ON saa.IdSubArticle=a.Id AND saa.IdArticle = 1817 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:77
SELECT *
FROM shop_article
WHERE Id=1938
select properties of object shop article
Dotaz cislo:78
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1938 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:79
SELECT *
FROM shop_art2cat WHERE IdArticle = '1938'
select properties of object CShopArt2Cat
Dotaz cislo:80
SELECT *
FROM shop_art2serie WHERE IdArticle = '1938'
select properties of object CShopArt2Cat
Dotaz cislo:81
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:82
SELECT *
FROM shop_art2file WHERE IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:83
SELECT *
FROM shop_attributes WHERE IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:84
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 706 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:85
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 724 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:86
SELECT *
FROM shop_art2flag WHERE IdArticle = '1938' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:87
SELECT *
FROM shop_art2vat WHERE IdArticle = '1938'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:88
SELECT *
FROM shop_anchor WHERE IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:89
SELECT *
FROM virtual_directory WHERE IdItem = 1938 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:90
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=6208 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:91
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1938)
nebylo zadano
Dotaz cislo:92
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1938 OR a.IdParent=1938) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:93
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1938' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:94
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:95
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1938 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:96
SELECT *
FROM shop_article
WHERE Id=1802
select properties of object shop article
Dotaz cislo:97
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1802 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:98
SELECT *
FROM shop_art2cat WHERE IdArticle = '1802'
select properties of object CShopArt2Cat
Dotaz cislo:99
SELECT *
FROM shop_art2serie WHERE IdArticle = '1802'
select properties of object CShopArt2Cat
Dotaz cislo:100
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:101
SELECT *
FROM shop_art2file WHERE IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:102
SELECT *
FROM shop_attributes WHERE IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:103
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1756 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:104
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1757 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:105
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1758 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:106
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1759 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:107
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 2395 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:108
SELECT *
FROM shop_art2flag WHERE IdArticle = '1802' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:109
SELECT *
FROM shop_art2vat WHERE IdArticle = '1802'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:110
SELECT *
FROM shop_anchor WHERE IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:111
SELECT *
FROM virtual_directory WHERE IdItem = 1802 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:112
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5442 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:113
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1802)
nebylo zadano
Dotaz cislo:114
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1802 OR a.IdParent=1802) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:115
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1802' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:116
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1802 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:117
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1938
nebylo zadano
Dotaz cislo:118
SELECT *
FROM shop_cat_tree
WHERE Id=87
select properties of object shop category
Dotaz cislo:119
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=87 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:120
SELECT *
FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:121
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7282 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:122
SELECT *
FROM shop_producer
WHERE Id=14
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
Dotaz cislo:123
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:124
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:125
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=2
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:126
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=5
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:127
SELECT *
FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:128
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7356 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:129
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:130
SELECT *
FROM virtual_directory
WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:131
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:132
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:133
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:134
SELECT *
FROM images
WHERE Id=1091
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:135
SELECT *
FROM shop_storage
WHERE Id=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
Dotaz cislo:136
SELECT *
FROM shop_storage2lang WHERE IdStorage = '1'
ORDER BY Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
Dotaz cislo:137
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=77 AND
CountTo>=77
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Tip
Akce
Dárek zdarma
Doprava zdarma
EKO bobr do mikrovlnky - nahřívací
Katalogové číslo: AiviAiviab1817
Dotaz cislo:138
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1938'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:139
SELECT *
FROM images
WHERE Id=611
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Skladem
Dotaz cislo:140
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1802
nebylo zadano
Dotaz cislo:141
SELECT *
FROM shop_cat_tree
WHERE Id=86
select properties of object shop category
Dotaz cislo:142
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=86 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:143
SELECT *
FROM virtual_directory WHERE IdItem = 86 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:144
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7409 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:145
SELECT *
FROM shop_producer
WHERE Id=14
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
Dotaz cislo:146
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:147
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:148
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=2
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:149
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=5
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:150
SELECT *
FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:151
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7356 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:152
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:153
SELECT *
FROM virtual_directory
WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:154
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:155
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:156
SELECT *
FROM images
WHERE Id=929
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:157
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=196 AND
CountTo>=196
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Černý Mercedes Benz Veterán
Katalogové číslo: ab1802
Dotaz cislo:158
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1802'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Skladem
Související výrobky
Dotaz cislo:159
SELECT al.Name, al.ShortName, al.Description, al.Flags as LangFlags, al.SubName, a.*, a2i.IdImage, mu.Value as MUName, vd2l.Name as DirectoryName FROM shop_article a INNER JOIN shop_art2lang al ON al.IdArticle=a.Id AND al.IdLanguage = 1 LEFT JOIN shop_art2img a2i ON a2i.IdArticle=a.Id AND a2i.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.Id) LEFT JOIN shop_mu mu ON mu.Id=a.IdMU AND mu.IdLanguage=1 INNER JOIN virtual_directory vd ON vd.IdSecuritySection = 17 AND vd.IdItem = a.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=1 INNER JOIN shop_cost sc ON sc.IdArticle=a.Id AND sc.IdType=3 AND sc.value>0 INNER JOIN shop_interrelated_articles saa ON saa.IdRelArticle=a.Id AND saa.IdArticle = 1817 AND saa.IdType=0 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:160
SELECT *
FROM shop_article
WHERE Id=1938
select properties of object shop article
Dotaz cislo:161
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1938 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:162
SELECT *
FROM shop_art2cat WHERE IdArticle = '1938'
select properties of object CShopArt2Cat
Dotaz cislo:163
SELECT *
FROM shop_art2serie WHERE IdArticle = '1938'
select properties of object CShopArt2Cat
Dotaz cislo:164
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:165
SELECT *
FROM shop_art2file WHERE IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:166
SELECT *
FROM shop_attributes WHERE IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:167
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 706 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:168
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 724 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:169
SELECT *
FROM shop_art2flag WHERE IdArticle = '1938' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:170
SELECT *
FROM shop_art2vat WHERE IdArticle = '1938'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:171
SELECT *
FROM shop_anchor WHERE IdArticle = '1938'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:172
SELECT *
FROM virtual_directory WHERE IdItem = 1938 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:173
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=6208 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:174
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1938)
nebylo zadano
Dotaz cislo:175
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1938 OR a.IdParent=1938) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:176
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1938' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:177
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1938 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:178
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1938
nebylo zadano
Dotaz cislo:179
SELECT *
FROM shop_cat_tree
WHERE Id=87
select properties of object shop category
Dotaz cislo:180
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=87 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:181
SELECT *
FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:182
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7282 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:183
SELECT *
FROM shop_producer
WHERE Id=14
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
Dotaz cislo:184
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:185
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:186
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=2
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:187
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=5
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:188
SELECT *
FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:189
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7356 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:190
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:191
SELECT *
FROM virtual_directory
WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:192
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:193
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:194
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:195
SELECT *
FROM images
WHERE Id=1091
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:196
SELECT *
FROM shop_storage
WHERE Id=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
Dotaz cislo:197
SELECT *
FROM shop_storage2lang WHERE IdStorage = '1'
ORDER BY Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
Dotaz cislo:198
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=77 AND
CountTo>=77
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Tip
Akce
Dárek zdarma
Doprava zdarma
EKO bobr do mikrovlnky - nahřívací
Katalogové číslo: AiviAiviab1817
Dotaz cislo:199
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1938'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:200
SELECT *
FROM images
WHERE Id=611
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Skladem
Související kategorie
Dotaz cislo:201
SELECT DISTINCT t.Id, t2l.Name
FROM shop_cat_tree t
INNER JOIN shop_cat_tree2lang t2l ON t2l.IdCat = t.Id AND
t2l.IdLanguage = 1 AND
t2l.Flags & 1 = 1
INNER JOIN shop_interrelated_articles sia ON sia.IdArticle = 1817 AND sia.IdType = 1 AND sia.IdRelArticle = t.Id
LEFT JOIN shop_cat2img t2i ON t2i.IdCategory = t.Id
ORDER BY sia.colOrder
interrelated categories for article
Příslušenství
Dotaz cislo:202
SELECT al.Name, al.ShortName, al.Description, al.Flags as LangFlags, al.SubName, a.*, a2i.IdImage, mu.Value as MUName, vd2l.Name as DirectoryName FROM shop_article a INNER JOIN shop_art2lang al ON al.IdArticle=a.Id AND al.IdLanguage = 1 LEFT JOIN shop_art2img a2i ON a2i.IdArticle=a.Id AND a2i.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.Id) LEFT JOIN shop_mu mu ON mu.Id=a.IdMU AND mu.IdLanguage=1 INNER JOIN virtual_directory vd ON vd.IdSecuritySection = 17 AND vd.IdItem = a.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=1 INNER JOIN shop_cost sc ON sc.IdArticle=a.Id AND sc.IdType=3 AND sc.value>0 INNER JOIN shop_accessories_articles saa ON saa.IdAccArticle=a.Id AND saa.IdArticle = 1817 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:203
SELECT *
FROM shop_article
WHERE Id=1822
select properties of object shop article
Dotaz cislo:204
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1822 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:205
SELECT *
FROM shop_art2cat WHERE IdArticle = '1822'
select properties of object CShopArt2Cat
Dotaz cislo:206
SELECT *
FROM shop_art2serie WHERE IdArticle = '1822'
select properties of object CShopArt2Cat
Dotaz cislo:207
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1822'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:208
SELECT *
FROM shop_art2file WHERE IdArticle = '1822'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:209
SELECT *
FROM shop_attributes WHERE IdArticle = '1822'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:210
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 494 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:211
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 497 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:212
SELECT *
FROM shop_art2flag WHERE IdArticle = '1822' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:213
SELECT *
FROM shop_art2vat WHERE IdArticle = '1822'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:214
SELECT *
FROM shop_anchor WHERE IdArticle = '1822'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:215
SELECT *
FROM virtual_directory WHERE IdItem = 1822 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:216
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5462 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:217
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1822)
nebylo zadano
Dotaz cislo:218
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1822 OR a.IdParent=1822) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:219
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1822' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:220
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1822 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:221
SELECT *
FROM shop_article
WHERE Id=1828
select properties of object shop article
Dotaz cislo:222
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1828 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:223
SELECT *
FROM shop_art2cat WHERE IdArticle = '1828'
select properties of object CShopArt2Cat
Dotaz cislo:224
SELECT *
FROM shop_art2serie WHERE IdArticle = '1828'
select properties of object CShopArt2Cat
Dotaz cislo:225
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:226
SELECT *
FROM shop_art2file WHERE IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:227
SELECT *
FROM shop_attributes WHERE IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:228
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 642 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:229
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 673 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:230
SELECT *
FROM shop_art2flag WHERE IdArticle = '1828' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:231
SELECT *
FROM shop_art2vat WHERE IdArticle = '1828'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:232
SELECT *
FROM shop_anchor WHERE IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:233
SELECT *
FROM virtual_directory WHERE IdItem = 1828 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:234
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5468 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:235
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1828)
nebylo zadano
Dotaz cislo:236
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1828 OR a.IdParent=1828) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:237
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1828' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:238
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1828 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:239
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1822
nebylo zadano
Dotaz cislo:240
SELECT *
FROM shop_cat_tree
WHERE Id=91
select properties of object shop category
Dotaz cislo:241
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=91 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:242
SELECT *
FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:243
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7391 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:244
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:245
SELECT *
FROM images
WHERE Id=914
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:246
SELECT *
FROM shop_storage
WHERE Id=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
Dotaz cislo:247
SELECT *
FROM shop_storage2lang WHERE IdStorage = '1'
ORDER BY Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
Dotaz cislo:248
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=1 AND
CountTo>=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Darth Vader 21% DPH
Katalogové číslo: dph21
Dotaz cislo:249
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1822'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:250
SELECT *
FROM images
WHERE Id=611
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Skladem
Dotaz cislo:251
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1828
nebylo zadano
Dotaz cislo:252
SELECT *
FROM shop_cat_tree
WHERE Id=92
select properties of object shop category
Dotaz cislo:253
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=92 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:254
SELECT *
FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:255
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7331 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:256
SELECT *
FROM images
WHERE Id=923
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:257
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=160 AND
CountTo>=160
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Dětské retro vozítko růžové
Katalogové číslo: ab1828
Dotaz cislo:258
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1828'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Skladem
Alternativní výrobky
Dotaz cislo:259
SELECT al.Name, al.ShortName, al.Description, al.Flags as LangFlags, al.SubName, a.*, a2i.IdImage, mu.Value as MUName, vd2l.Name as DirectoryName FROM shop_article a INNER JOIN shop_art2lang al ON al.IdArticle=a.Id AND al.IdLanguage = 1 LEFT JOIN shop_art2img a2i ON a2i.IdArticle=a.Id AND a2i.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.Id) LEFT JOIN shop_mu mu ON mu.Id=a.IdMU AND mu.IdLanguage=1 INNER JOIN virtual_directory vd ON vd.IdSecuritySection = 17 AND vd.IdItem = a.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=1 INNER JOIN shop_cost sc ON sc.IdArticle=a.Id AND sc.IdType=3 AND sc.value>0 INNER JOIN shop_alternated_articles saa ON saa.IdAltArticle=a.Id AND saa.IdArticle = 1817 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:260
SELECT *
FROM shop_article
WHERE Id=1829
select properties of object shop article
Dotaz cislo:261
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1829 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:262
SELECT *
FROM shop_art2cat WHERE IdArticle = '1829'
select properties of object CShopArt2Cat
Dotaz cislo:263
SELECT *
FROM shop_art2serie WHERE IdArticle = '1829'
select properties of object CShopArt2Cat
Dotaz cislo:264
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1829'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:265
SELECT *
FROM shop_art2file WHERE IdArticle = '1829'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:266
SELECT *
FROM shop_attributes WHERE IdArticle = '1829'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:267
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 634 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:268
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 640 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:269
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 671 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:270
SELECT *
FROM shop_art2flag WHERE IdArticle = '1829' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:271
SELECT *
FROM shop_art2vat WHERE IdArticle = '1829'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:272
SELECT *
FROM shop_anchor WHERE IdArticle = '1829'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:273
SELECT *
FROM virtual_directory WHERE IdItem = 1829 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:274
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5469 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:275
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1829)
nebylo zadano
Dotaz cislo:276
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1829 OR a.IdParent=1829) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:277
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1829' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:278
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1829 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:279
SELECT *
FROM shop_article
WHERE Id=1827
select properties of object shop article
Dotaz cislo:280
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1827 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:281
SELECT *
FROM shop_art2cat WHERE IdArticle = '1827'
select properties of object CShopArt2Cat
Dotaz cislo:282
SELECT *
FROM shop_art2serie WHERE IdArticle = '1827'
select properties of object CShopArt2Cat
Dotaz cislo:283
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1827'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:284
SELECT *
FROM shop_art2file WHERE IdArticle = '1827'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:285
SELECT *
FROM shop_attributes WHERE IdArticle = '1827'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:286
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 482 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:287
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 483 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:288
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 492 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:289
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 500 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:290
SELECT *
FROM shop_art2flag WHERE IdArticle = '1827' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:291
SELECT *
FROM shop_art2vat WHERE IdArticle = '1827'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:292
SELECT *
FROM shop_anchor WHERE IdArticle = '1827'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:293
SELECT *
FROM virtual_directory WHERE IdItem = 1827 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:294
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5467 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:295
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1827)
nebylo zadano
Dotaz cislo:296
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1827 OR a.IdParent=1827) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:297
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1827' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:298
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1827 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:299
SELECT *
FROM shop_article
WHERE Id=1802
select properties of object shop article
Dotaz cislo:300
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1802 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:301
SELECT *
FROM shop_art2cat WHERE IdArticle = '1802'
select properties of object CShopArt2Cat
Dotaz cislo:302
SELECT *
FROM shop_art2serie WHERE IdArticle = '1802'
select properties of object CShopArt2Cat
Dotaz cislo:303
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:304
SELECT *
FROM shop_art2file WHERE IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:305
SELECT *
FROM shop_attributes WHERE IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:306
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1756 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:307
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1757 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:308
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1758 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:309
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 1759 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:310
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 2395 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:311
SELECT *
FROM shop_art2flag WHERE IdArticle = '1802' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:312
SELECT *
FROM shop_art2vat WHERE IdArticle = '1802'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:313
SELECT *
FROM shop_anchor WHERE IdArticle = '1802'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:314
SELECT *
FROM virtual_directory WHERE IdItem = 1802 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:315
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5442 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:316
SELECT Value
FROM shop_cost_vat
WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat)
FROM shop_article a
LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1802)
nebylo zadano
Dotaz cislo:317
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost,
(c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost,
a.Flags, a.Id
FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND
c.IdType=3
LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType
LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND
c2.MinCount<=1 AND c2.IdCompany IS NULL
WHERE (a.Id=1802 OR a.IdParent=1802) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:318
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1802' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:56:46' AND TimeTo > '2025-07-06 01:56:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:319
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1802 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:320
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1829
nebylo zadano
Dotaz cislo:321
SELECT *
FROM shop_cat_tree
WHERE Id=92
select properties of object shop category
Dotaz cislo:322
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=92 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:323
SELECT *
FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:324
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7331 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:325
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:326
SELECT *
FROM images
WHERE Id=921
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:327
SELECT *
FROM shop_storage
WHERE Id=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
Dotaz cislo:328
SELECT *
FROM shop_storage2lang WHERE IdStorage = '1'
ORDER BY Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
Dotaz cislo:329
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=60 AND
CountTo>=60
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Dětské retro vozítko bílé
Katalogové číslo: ab1829
Dotaz cislo:330
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1829'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:331
SELECT *
FROM images
WHERE Id=611
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Skladem
Dotaz cislo:332
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1827
nebylo zadano
Dotaz cislo:333
SELECT *
FROM shop_cat_tree
WHERE Id=92
select properties of object shop category
Dotaz cislo:334
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=92 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:335
SELECT *
FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:336
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7331 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:337
SELECT *
FROM images
WHERE Id=925
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:338
SELECT *
FROM shop_storage
WHERE Id=3
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
Dotaz cislo:339
SELECT *
FROM shop_storage2lang WHERE IdStorage = '3'
ORDER BY Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
Dotaz cislo:340
SELECT * FROM shop_storage_count
WHERE IdStorage=3 AND
CountFrom<=0 AND
CountTo>=0
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Dětské retro vozítko žluté
Katalogové číslo: ab1827
Dotaz cislo:341
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1827'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:342
SELECT *
FROM images
WHERE Id=1327
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Externí sklad
Dotaz cislo:343
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1802
nebylo zadano
Dotaz cislo:344
SELECT *
FROM shop_cat_tree
WHERE Id=86
select properties of object shop category
Dotaz cislo:345
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=86 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:346
SELECT *
FROM virtual_directory WHERE IdItem = 86 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:347
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7409 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:348
SELECT *
FROM shop_producer
WHERE Id=14
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
Dotaz cislo:349
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:350
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:351
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=2
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:352
SELECT * FROM shop_producer2lang
WHERE IdProducer=14 AND
IdLanguage=5
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
Dotaz cislo:353
SELECT *
FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:354
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7356 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:355
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:356
SELECT *
FROM virtual_directory
WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:357
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:358
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:359
SELECT *
FROM images
WHERE Id=929
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:360
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=196 AND
CountTo>=196
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Černý Mercedes Benz Veterán
Katalogové číslo: ab1802
Dotaz cislo:361
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1802'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Skladem