Dětské odrážedlo ve stylu žlutého veterána.
Dětské odrážedlo ve stylu žlutého veterána, Dlouhý popis.
Dotaz cislo:83
SELECT *
FROM shop_mu
WHERE Id=3 AND
IdLanguage=1
select properties of object CShopMU
Dotaz cislo:84
SELECT *
FROM shop_attributes WHERE IdParent = '2211' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:85
SELECT *
FROM shop_attributes WHERE IdParent = '2341' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:86
SELECT *
FROM shop_attributes WHERE IdParent = '2328' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:87
SELECT *
FROM shop_attributes WHERE IdParent = '2315' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:88
SELECT *
FROM shop_attributes WHERE IdParent = '2302' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:89
SELECT *
FROM shop_attributes WHERE IdParent = '2276' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:90
SELECT *
FROM shop_attributes WHERE IdParent = '2263' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:91
SELECT *
FROM shop_attributes WHERE IdParent = '2224' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:92
SELECT *
FROM shop_attributes WHERE IdParent = '2289' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:93
SELECT *
FROM shop_mu
WHERE Id=1 AND
IdLanguage=1
select properties of object CShopMU
Dotaz cislo:94
SELECT *
FROM shop_attributes WHERE IdParent = '2237' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:95
SELECT *
FROM shop_attributes WHERE IdParent = '2250' AND IdArticle = '1846'
ORDER BY colOrder
select properties of object CShopAttributes
Vlastnosti
|
Název vlastnosti |
Hodnota |
Dotaz cislo:96
SELECT *
FROM shop_search
WHERE Id=2
select properties of object CShopSearch
Dotaz cislo:97
SELECT *
FROM shop_search2lang
WHERE IdSearch = 2 AND
IdLanguage = 1
select properties of object shop_serach2lang
Dotaz cislo:98
SELECT *
FROM shop_search2cat WHERE IdSearch = '2'
ORDER BY colOrder ASC
select properties of object CShopSearch2Cat
|
Váha |
|
Dotaz cislo:99
SELECT *
FROM shop_search
WHERE Id=3
select properties of object CShopSearch
Dotaz cislo:100
SELECT *
FROM shop_search2lang
WHERE IdSearch = 3 AND
IdLanguage = 1
select properties of object shop_serach2lang
Dotaz cislo:101
SELECT *
FROM shop_search2cat WHERE IdSearch = '3'
ORDER BY colOrder ASC
select properties of object CShopSearch2Cat
|
Věk |
44 , od 5 let |
Položky v sestavě
Dotaz cislo:102
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 = 1846 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Související výrobky
Dotaz cislo:103
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 = 1846 AND saa.IdType=0 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:104
SELECT *
FROM shop_article
WHERE Id=1905
select properties of object shop article
Dotaz cislo:105
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1905 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:106
SELECT *
FROM shop_art2cat WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:107
SELECT *
FROM shop_art2serie WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:108
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:109
SELECT *
FROM shop_art2file WHERE IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:110
SELECT *
FROM shop_attributes WHERE IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:111
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 580 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:112
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 583 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:113
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 581 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:114
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 635 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:115
SELECT *
FROM shop_art2flag WHERE IdArticle = '1905' 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:116
SELECT *
FROM shop_art2vat WHERE IdArticle = '1905'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:117
SELECT *
FROM shop_anchor WHERE IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:118
SELECT * FROM shop_anchor2lang
WHERE
IdAnchor=1 AND
IdLanguage=1
select properties of object shop_attributes2lang
Dotaz cislo:119
SELECT *
FROM virtual_directory WHERE IdItem = 1905 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:120
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5627 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:121
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=1905)
nebylo zadano
Dotaz cislo:122
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=1905 OR a.IdParent=1905) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:123
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1905' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:49:59' AND TimeTo > '2025-07-06 01:49:59' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:124
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:125
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1905 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:126
SELECT *
FROM shop_article
WHERE Id=1925
select properties of object shop article
Dotaz cislo:127
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1925 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:128
SELECT *
FROM shop_art2cat WHERE IdArticle = '1925'
select properties of object CShopArt2Cat
Dotaz cislo:129
SELECT *
FROM shop_art2serie WHERE IdArticle = '1925'
select properties of object CShopArt2Cat
Dotaz cislo:130
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1925'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:131
SELECT *
FROM shop_art2file WHERE IdArticle = '1925'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:132
SELECT *
FROM shop_attributes WHERE IdArticle = '1925'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:133
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 593 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:134
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 594 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:135
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 595 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:136
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 596 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:137
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 633 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:138
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 639 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:139
SELECT *
FROM shop_art2flag WHERE IdArticle = '1925' 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:140
SELECT *
FROM shop_art2vat WHERE IdArticle = '1925'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:141
SELECT *
FROM shop_anchor WHERE IdArticle = '1925'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:142
SELECT *
FROM virtual_directory WHERE IdItem = 1925 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:143
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=6113 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:144
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=1925)
nebylo zadano
Dotaz cislo:145
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=1925 OR a.IdParent=1925) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:146
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1925' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:49:59' AND TimeTo > '2025-07-06 01:49:59' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:147
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1925 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:148
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1905
nebylo zadano
Dotaz cislo:149
SELECT *
FROM shop_cat_tree
WHERE Id=87
select properties of object shop category
Dotaz cislo:150
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=87 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:151
SELECT *
FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:152
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7282 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:153
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:154
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:155
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:156
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:157
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:158
SELECT *
FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:159
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7356 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:160
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:161
SELECT *
FROM virtual_directory
WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:162
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:163
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:164
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:165
SELECT *
FROM images
WHERE Id=928
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:166
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:167
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:168
SELECT * FROM shop_storage_count
WHERE IdStorage=1 AND
CountFrom<=199 AND
CountTo>=199
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
Speciální doprava 1 500 Kč
Video
Sleva 20%
Výprodej
Omezený počet kusů
Nebude již aplikována žádná další sleva.
Zaváděcí cena
Auto německé dálniční policie 1:43
doplněk stravy
Katalogové číslo: testimport
1 500 Kč
1 200 Kč
s DPH
/ lahev
Dotaz cislo:169
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1905'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:170
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:171
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1925
nebylo zadano
Dotaz cislo:172
SELECT *
FROM images
WHERE Id=584
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:173
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:174
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:175
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
Chlazení na pivo CWP 200 Green Line 4xsmyčka + rychlospojky
Katalogové číslo: CWP00476
26 957,57 Kč
121 Kč
s DPH
Dotaz cislo:176
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1925'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:177
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
Související kategorie
Dotaz cislo:178
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 = 1846 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:179
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 = 1846 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:180
SELECT *
FROM shop_article
WHERE Id=1815
select properties of object shop article
Dotaz cislo:181
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1815 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:182
SELECT *
FROM shop_art2cat WHERE IdArticle = '1815'
select properties of object CShopArt2Cat
Dotaz cislo:183
SELECT *
FROM shop_art2serie WHERE IdArticle = '1815'
select properties of object CShopArt2Cat
Dotaz cislo:184
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1815'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:185
SELECT *
FROM shop_art2file WHERE IdArticle = '1815'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:186
SELECT *
FROM shop_attributes WHERE IdArticle = '1815'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:187
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 660 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:188
SELECT *
FROM shop_art2flag WHERE IdArticle = '1815' 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:189
SELECT *
FROM shop_art2vat WHERE IdArticle = '1815'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:190
SELECT *
FROM shop_anchor WHERE IdArticle = '1815'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:191
SELECT *
FROM virtual_directory WHERE IdItem = 1815 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:192
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5455 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:193
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=1815)
nebylo zadano
Dotaz cislo:194
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=1815 OR a.IdParent=1815) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:195
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1815' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:49:59' AND TimeTo > '2025-07-06 01:49:59' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:196
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1815 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:197
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1815
nebylo zadano
Dotaz cislo:198
SELECT *
FROM shop_cat_tree
WHERE Id=90
select properties of object shop category
Dotaz cislo:199
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=90 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:200
SELECT *
FROM virtual_directory WHERE IdItem = 90 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:201
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7389 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:202
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:203
SELECT *
FROM images
WHERE Id=904
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:204
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:205
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:206
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
Dvě dřevěné včelky
Katalogové číslo: ab1815
Dotaz cislo:207
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1815'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:208
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
Alternativní výrobky
Dotaz cislo:209
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 = 1846 WHERE al.Flags&1 ORDER BY saa.colOrder ASC
Dotaz cislo:210
SELECT *
FROM shop_article
WHERE Id=1828
select properties of object shop article
Dotaz cislo:211
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1828 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:212
SELECT *
FROM shop_art2cat WHERE IdArticle = '1828'
select properties of object CShopArt2Cat
Dotaz cislo:213
SELECT *
FROM shop_art2serie WHERE IdArticle = '1828'
select properties of object CShopArt2Cat
Dotaz cislo:214
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:215
SELECT *
FROM shop_art2file WHERE IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:216
SELECT *
FROM shop_attributes WHERE IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:217
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 642 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:218
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 673 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:219
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:220
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:221
SELECT *
FROM shop_anchor WHERE IdArticle = '1828'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:222
SELECT *
FROM virtual_directory WHERE IdItem = 1828 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:223
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5468 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:224
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:225
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:226
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1828' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:49:59' AND TimeTo > '2025-07-06 01:49:59' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:227
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1828 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:228
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1828
nebylo zadano
Dotaz cislo:229
SELECT *
FROM shop_cat_tree
WHERE Id=92
select properties of object shop category
Dotaz cislo:230
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=92 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:231
SELECT *
FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:232
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7331 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:233
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:234
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:235
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:236
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:237
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:238
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
Dotaz cislo:239
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
Přihlášení Seznam.cz
+420 777 721 282