Dotaz cislo:195
SELECT al.Name, CASE WHEN a.IdParent = 0 THEN al.ShortName ELSE '' END AS ShortName , al.Description, al.Flags as LangFlags, al.SubName, a.*, a2i.IdImage, a2i2.IdImage as IdImageParent, mu.Value as MUName, vd2l.Name as DirectoryName, sum(oi.Count) as Cnt, true as IdFlag FROM shop_article a INNER JOIN shop_art2lang al ON al.IdArticle=a.Id AND al.IdLanguage = 1 INNER JOIN shop_order_items oi ON a.Id=oi.IdArticle INNER JOIN shop_cost sc ON sc.IdArticle=oi.IdArticle AND sc.IdType=3 AND sc.value>0 INNER JOIN shop_order o ON o.Id=oi.IdOrder AND date_sub(CURDATE(), INTERVAL 30 DAY) <= o.InsertTime AND o.Status >= 11 LEFT JOIN shop_art2img a2i ON a2i.IdArticle=a.Id AND a2i.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.Id ORDER BY colOrder LIMIT 1) LEFT JOIN shop_art2img a2i2 ON a2i2.IdArticle=a.IdParent AND a2i2.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.IdParent ORDER BY colOrder LIMIT 1) 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 WHERE al.Flags&1 GROUP BY IFNULL(a.IdParent, a.Id) ORDER BY Cnt DESC, a.Id DESC LIMIT 0, 10
Dotaz cislo:196
SELECT *
FROM shop_article
WHERE Id=1905
select properties of object shop article
Dotaz cislo:197
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1905 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:198
SELECT *
FROM shop_art2cat WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:199
SELECT *
FROM shop_art2serie WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:200
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:201
SELECT *
FROM shop_art2file WHERE IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:202
SELECT *
FROM shop_attributes WHERE IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:203
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 580 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:204
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 583 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:205
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 581 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:206
SELECT * FROM shop_attributes2lang
WHERE IdAttribute = 635 AND
IdLanguage = 1
select properties of object shop_attributes2lang
Dotaz cislo:207
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:208
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:209
SELECT *
FROM shop_anchor WHERE IdArticle = '1905'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:210
SELECT * FROM shop_anchor2lang
WHERE
IdAnchor=1 AND
IdLanguage=1
select properties of object shop_attributes2lang
Dotaz cislo:211
SELECT *
FROM virtual_directory WHERE IdItem = 1905 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:212
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5627 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:213
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:214
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:215
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1905' AND IdCostType = '3' AND TimeFrom < '2025-07-06 02:06:46' AND TimeTo > '2025-07-06 02:06:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:216
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:217
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1905 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:218
SELECT *
FROM shop_article
WHERE Id=1821
select properties of object shop article
Dotaz cislo:219
SELECT *
FROM shop_art2lang
WHERE IdArticle = 1821 AND
IdLanguage = 1
select shop_art2lang
Dotaz cislo:220
SELECT *
FROM shop_art2cat WHERE IdArticle = '1821'
select properties of object CShopArt2Cat
Dotaz cislo:221
SELECT *
FROM shop_art2serie WHERE IdArticle = '1821'
select properties of object CShopArt2Cat
Dotaz cislo:222
SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1821'
ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:223
SELECT *
FROM shop_art2file WHERE IdArticle = '1821'
ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:224
SELECT *
FROM shop_attributes WHERE IdArticle = '1821'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:225
SELECT *
FROM shop_art2flag WHERE IdArticle = '1821' 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:226
SELECT *
FROM shop_art2vat WHERE IdArticle = '1821'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:227
SELECT *
FROM shop_anchor WHERE IdArticle = '1821'
ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:228
SELECT *
FROM virtual_directory WHERE IdItem = 1821 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:229
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5461 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:230
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=1821)
nebylo zadano
Dotaz cislo:231
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=1821 OR a.IdParent=1821) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1
select vat to article
Dotaz cislo:232
SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1821' AND IdCostType = '3' AND TimeFrom < '2025-07-06 02:06:46' AND TimeTo > '2025-07-06 02:06:46' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:233
SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1821 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:234
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1905
nebylo zadano
Dotaz cislo:235
SELECT *
FROM shop_cat_tree
WHERE Id=87
select properties of object shop category
Dotaz cislo:236
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=87 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:237
SELECT *
FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:238
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7282 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:239
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:240
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:241
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:242
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:243
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:244
SELECT *
FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:245
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7356 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:246
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:247
SELECT *
FROM virtual_directory
WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:248
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:249
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:250
SELECT *
FROM shop_cost_vat
WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:251
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:252
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:253
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:254
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
Dotaz cislo:255
SELECT *
FROM shop_art2flag
WHERE IdArticle=1905 AND ((TimeFrom
=CURRENT_DATE OR (TimeTo IS NULL))
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10714 in method CShopArt2Flag::getActiveForArticle
Dotaz cislo:256
SELECT *
FROM shop_flag
WHERE Id=2
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
Dotaz cislo:257
SELECT * FROM shop_flag2lang
WHERE
IdFlag =2 AND
IdLanguage =1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
Dotaz cislo:258
SELECT *
FROM shop_flag2cat WHERE IdFlag = '2'
ORDER BY colOrder ASC
select properties of object CShopFlag2Cat
Dotaz cislo:259
SELECT *
FROM images
WHERE Id=628
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Pouze osobní odběr Dotaz cislo:260
SELECT *
FROM shop_flag
WHERE Id=3
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
Dotaz cislo:261
SELECT * FROM shop_flag2lang
WHERE
IdFlag =3 AND
IdLanguage =1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
Dotaz cislo:262
SELECT *
FROM shop_flag2cat WHERE IdFlag = '3'
ORDER BY colOrder ASC
select properties of object CShopFlag2Cat
Dotaz cislo:263
SELECT *
FROM images
WHERE Id=1038
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
EPUB Dotaz cislo:264
SELECT *
FROM shop_flag
WHERE Id=5
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
Dotaz cislo:265
SELECT * FROM shop_flag2lang
WHERE
IdFlag =5 AND
IdLanguage =1
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
Dotaz cislo:266
SELECT *
FROM shop_flag2cat WHERE IdFlag = '5'
ORDER BY colOrder ASC
select properties of object CShopFlag2Cat
XXX
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:267
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:268
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:269
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1821
nebylo zadano
Dotaz cislo:270
SELECT *
FROM shop_cat_tree
WHERE Id=91
select properties of object shop category
Dotaz cislo:271
SELECT * FROM shop_cat_tree2lang
WHERE IdCat=91 AND
IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:272
SELECT *
FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:273
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7391 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:274
SELECT *
FROM shop_producer
WHERE Id=16
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
Dotaz cislo:275
SELECT *
FROM _language
ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:276
SELECT * FROM shop_producer2lang
WHERE IdProducer=16 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:277
SELECT * FROM shop_producer2lang
WHERE IdProducer=16 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:278
SELECT * FROM shop_producer2lang
WHERE IdProducer=16 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:279
SELECT *
FROM virtual_directory WHERE IdItem = 16 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:280
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7408 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:281
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7408'
select properties of object virtual_directpry_set
Dotaz cislo:282
SELECT *
FROM virtual_directory
WHERE Id=7408
select properties of object virtual_directory
Dotaz cislo:283
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7408
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:284
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7408'
select properties of object virtual_directpry_set
Dotaz cislo:285
SELECT *
FROM images
WHERE Id=916
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:286
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:287
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:288
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
Dotaz cislo:289
SELECT *
FROM shop_art2flag
WHERE IdArticle=1821 AND ((TimeFrom=CURRENT_DATE OR (TimeTo IS NULL))
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10714 in method CShopArt2Flag::getActiveForArticle
Robot C3PO
Katalogové číslo: C3PO
Dotaz cislo:290
SELECT *
FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1821'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
Dotaz cislo:291
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