Dotaz cislo:1
SELECT Name, Value FROM _config

Dotaz cislo:2
SELECT * FROM _language WHERE Id=1
select properties of object language
Dotaz cislo:3
SELECT * FROM template_page2lang WHERE Domain = 'dev.ai-shop.cz'
select properties of object template_page
Dotaz cislo:4
SELECT * FROM redirects WHERE URLOld='-197/'
select id of inserted redirects from db
Dotaz cislo:5
SELECT * FROM virtual_directory2lang WHERE Name LIKE '-197/'
select properties of object virtual_directory2lang
Dotaz cislo:6
SELECT * FROM virtual_directory WHERE Id=5617
select properties of object virtual_directory
Dotaz cislo:7
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 5617
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:8
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '5617'
select properties of object virtual_directpry_set
Dotaz cislo:9
SELECT * FROM _language WHERE Id=2
select properties of object language
Dotaz cislo:10
SELECT * FROM virtual_directory WHERE Id=5617
select properties of object virtual_directory
Dotaz cislo:11
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5617 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:12
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '5617'
select properties of object virtual_directpry_set
Dotaz cislo:13
SELECT * FROM exchange WHERE Id='112';
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsExchange.php on line 186 in method Cexchange::loadById
Dotaz cislo:14
SELECT Id, CONCAT(Name,' ',Surname) as Login,LogPassword,LogPasswordType, LogHash FROM security_user SU WHERE ((LogName='!Annonym') AND Flags&1) OR (LogHash ='' AND Loghash IS NOT NULL AND Loghash <>'' AND LogHashExpire > NOW() )
login user
Dotaz cislo:15
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=2 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:16
SELECT * FROM security_user2group WHERE IdUser=2
select groups of security_user
Dotaz cislo:17
call getRightsForUser(2, 52)
load rights
Dotaz cislo:18
SELECT * FROM company2user WHERE (1=1) AND IdUser = '2'
select properties of object company2user
Dotaz cislo:19
SELECT * FROM company WHERE Id=1
select properties of object company
Dotaz cislo:20
SELECT * FROM company2user WHERE (1=1) AND IdCompany = '1'
select properties of object company2user
Dotaz cislo:21
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=2 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:22
SELECT * FROM security_user2group WHERE IdUser=2
select groups of security_user
Dotaz cislo:23
SELECT * FROM template_page
select properties of object template_page
Dotaz cislo:24
SELECT * FROM template_page WHERE Id=29
select properties of object template_page
Dotaz cislo:25
SELECT * FROM template_page2lang WHERE IdPage=29 AND IdLanguage=2
select properties of object template_page
AiShop | - | Quality E-Shop
Dotaz cislo:239
SELECT * FROM section WHERE Id=237
select properties of object section
Dotaz cislo:240
SELECT * FROM section_sec2lang WHERE IdSection=237 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:241
SELECT * FROM section WHERE Id=263
select properties of object section
Dotaz cislo:242
SELECT * FROM section_sec2lang WHERE IdSection=263 AND IdLanguage=2
select properties of object section_sec2lang

Dotaz cislo:243
call getRightsForUser(2, 78)
load rights
Dotaz cislo:244
SELECT s.Id, s.IdParent as IdParent, s2l.Title as Title , '' as TargetTarget , s2l.Link as Name , s2l.Flags FROM menu_items s INNER JOIN menu_items2lang s2l ON s.Id=s2l.IdMenuItem AND s2l.IdLanguage = 2 AND s2l.Flags & 1 /*INNER JOIN virtual_directory vd ON vd.IdSecuritySection=s.IdSecuritySection AND vd.IdItem=s.IdItem INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=2*/ WHERE s.IdParent=1 AND s.Id IN (0, 1, 255, 256, 257, 258, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 284, 286, 287, 288, 289, 290, 291, 292, 294, 295, 296, 297, 298, 299, 300) ORDER BY colOrder LIMIT 6

Dotaz cislo:247
SELECT * FROM section WHERE Id=263
select properties of object section
Dotaz cislo:248
SELECT * FROM section_sec2lang WHERE IdSection=263 AND IdLanguage=2
select properties of object section_sec2lang

Dotaz cislo:257
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=2 WHERE v.IdItem=1 AND v.IdSecuritySection = 33
select id of inserted virtual_directory from db
Dotaz cislo:258
SELECT c.Id as Id, c.IdParent, CASE WHEN c2l.ShortName != '' THEN c2l.ShortName ELSE c2l.Name END AS Name, vd2l.`Name` as VD, i.Filename as Img, /*i2.Filename as Img2,*/ c.Color, c2l.Flags FlagsLang FROM shop_cat_tree c INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.Flags & 1 = 1 AND c2l.IdLanguage = 2 INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND c.Id=vd.IdItem INNER JOIN virtual_directory2lang vd2l ON vd2l.IdDirectory=vd.Id AND vd2l.IdLanguage=2 LEFT JOIN shop_cat2img c2i ON c2i.IdCategory = c.Id AND c2i.Flags & 4 LEFT JOIN images i ON i.Id = c2i.IdImage /*LEFT JOIN shop_cat2img c2i2 ON c2i2.IdCategory = c.Id AND c2i2.Flags & 1 LEFT JOIN images i2 ON i2.Id = c2i2.IdImage*/ WHERE /*c.IdParent<>0 AND ((c.Id in () AND c.IdParent=0) OR (c.IdParent<>0 AND c.IdParent<>0)) AND c.Id in () AND c.Flags & 1 AND*/ c2l.Name<>'' ORDER BY /*c.IdParent,*/ c.colOrder

Dotaz cislo:259
SELECT i2l.* FROM menu_items i INNER JOIN menu_items2lang i2l ON i.Id=i2l.IdMenuItem AND i2l.IdLanguage=2 AND i2l.Flags & 1 WHERE i.IdParent=268 ORDER BY colOrder
nebylo zadano
Dotaz cislo:260
SELECT * FROM images WHERE Id=1299
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:261
SELECT * FROM images WHERE Id=1287
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:268
SELECT * FROM section WHERE Id=201
select properties of object section
Dotaz cislo:269
SELECT * FROM section_sec2lang WHERE IdSection=201 AND IdLanguage=2
select properties of object section_sec2lang

Dotaz cislo:270
SELECT * FROM section WHERE Id=17
select properties of object section
Dotaz cislo:271
SELECT * FROM section_sec2lang WHERE IdSection=17 AND IdLanguage=2
select properties of object section_sec2lang

AIVision, s.r.o.
Ovenecká 15/1022
170 00 Praha 7

IČO: 27131955
DIČ: CZ27131955

+420 233 370 498
+420 608 224 380

info@aivision.cz
www.aivision.cz

 

Dotaz cislo:26
SELECT * FROM shop_article WHERE Id=1895
select properties of object shop article
Dotaz cislo:27
SELECT * FROM shop_art2lang WHERE IdArticle = 1895 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:28
SELECT * FROM shop_art2cat WHERE IdArticle = '1895'
select properties of object CShopArt2Cat
Dotaz cislo:29
SELECT * FROM shop_art2serie WHERE IdArticle = '1895'
select properties of object CShopArt2Cat
Dotaz cislo:30
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1895' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:31
SELECT * FROM shop_art2file WHERE IdArticle = '1895' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:32
SELECT * FROM shop_attributes WHERE IdArticle = '1895' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:33
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 514 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:34
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 515 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:35
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 516 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:36
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 676 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:37
SELECT * FROM shop_art2flag WHERE IdArticle = '1895' 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:38
SELECT * FROM shop_art2vat WHERE IdArticle = '1895'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:39
SELECT * FROM shop_anchor WHERE IdArticle = '1895' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:40
SELECT * FROM virtual_directory WHERE IdItem = 1895 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:41
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5617 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:42
SELECT * FROM shop_mu WHERE Id=1 AND IdLanguage=2
select properties of object CShopMU
Dotaz cislo:43
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1895
nebylo zadano
Dotaz cislo:44
SELECT * FROM shop_cat_tree WHERE Id=86
select properties of object shop category
Dotaz cislo:45
SELECT * FROM shop_cat_tree2lang WHERE IdCat=86 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:46
SELECT * FROM virtual_directory WHERE IdItem = 86 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:47
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7409 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:48
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:49
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:50
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:51
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=1895)
nebylo zadano
Dotaz cislo:52
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=1895 OR a.IdParent=1895) AND c.ValueWithVAT>0 ORDER BY c2.Value ASC, c.Value ASC LIMIT 0,1
select vat to article
Dotaz cislo:53
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1895' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:55:19' AND TimeTo > '2025-07-06 01:55:19' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:54
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1895 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:55
SELECT * FROM shop_art2lang WHERE IdArticle = 1801 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:56
SELECT kat2.Name as nazev, kat1.IdParent as idParent, kat1.Id as id, 1 as ShowItem FROM shop_cat_tree kat1 INNER JOIN shop_cat_tree2lang kat2 ON kat2.IdCat = kat1.Id WHERE kat1.Id = 86 AND IdLanguage = 2 AND kat2.Flags&1 GROUP BY idParent ORDER BY nazev
kategorie_v ceste CWriteTreePath
Dotaz cislo:57
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=2 WHERE v.IdItem=86 AND v.IdSecuritySection = 16
select id of inserted virtual_directory from db

-

-
Dotaz cislo:58
SELECT * FROM images WHERE Id=895
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
: ab1895
Dotaz cislo:59
SELECT * FROM shop_art2flag WHERE IdArticle=1895 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

RC model závoďáku v mierke 1/10.

:
7
Dotaz cislo:60
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1895 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:61
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:62
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
Dotaz cislo:63
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
External store
10,53 € Dotaz cislo:64
SELECT * FROM shop_mu WHERE Id=1 AND IdLanguage=2
select properties of object CShopMU
10,53 € /
Dotaz cislo:65
SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1895'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
10.53
Dotaz cislo:66
SELECT * FROM section WHERE Id=265
select properties of object section
Dotaz cislo:67
SELECT * FROM section_sec2lang WHERE IdSection=265 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:68
call getRightsForUser(2, 36)
load rights



RC model závoďáku v mierke 1/10.











 


 


 



 



Dotaz cislo:69
SELECT * FROM shop_mu WHERE Id=3 AND IdLanguage=2
select properties of object CShopMU
Dotaz cislo:70
SELECT * FROM shop_attributes WHERE IdParent = '514' AND IdArticle = '1895' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:71
SELECT * FROM shop_mu WHERE Id=1 AND IdLanguage=2
select properties of object CShopMU
Dotaz cislo:72
SELECT * FROM shop_attributes WHERE IdParent = '515' AND IdArticle = '1895' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:73
SELECT * FROM shop_attributes WHERE IdParent = '516' AND IdArticle = '1895' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:74
SELECT * FROM shop_attributes WHERE IdParent = '676' AND IdArticle = '1895' ORDER BY colOrder
select properties of object CShopAttributes

Dotaz cislo:75
SELECT * FROM shop_search WHERE Id=1
select properties of object CShopSearch
Dotaz cislo:76
SELECT * FROM shop_search2lang WHERE IdSearch = 1 AND IdLanguage = 1
select properties of object shop_serach2lang
Dotaz cislo:77
SELECT * FROM shop_search2cat WHERE IdSearch = '1' ORDER BY colOrder ASC
select properties of object CShopSearch2Cat
Color okrová

Dotaz cislo:78
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 = 2 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=2 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=2 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 = 1895 WHERE al.Flags&1 ORDER BY saa.colOrder ASC

Dotaz cislo:79
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 = 2 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=2 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=2 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 = 1895 AND saa.IdType=0 WHERE al.Flags&1 ORDER BY saa.colOrder ASC

Dotaz cislo:80
SELECT * FROM shop_article WHERE Id=1905
select properties of object shop article
Dotaz cislo:81
SELECT * FROM shop_art2lang WHERE IdArticle = 1905 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:82
SELECT * FROM shop_art2cat WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:83
SELECT * FROM shop_art2serie WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:84
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1905' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:85
SELECT * FROM shop_art2file WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:86
SELECT * FROM shop_attributes WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:87
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 580 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:88
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 583 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:89
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 581 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:90
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 635 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:91
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:92
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:93
SELECT * FROM shop_anchor WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:94
SELECT * FROM shop_anchor2lang WHERE IdAnchor=1 AND IdLanguage=2
select properties of object shop_attributes2lang
Dotaz cislo:95
SELECT * FROM virtual_directory WHERE IdItem = 1905 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:96
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5627 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:97
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:98
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:99
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1905' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:55:19' AND TimeTo > '2025-07-06 01:55:19' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:100
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:101
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1905 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:102
SELECT * FROM shop_article WHERE Id=1822
select properties of object shop article
Dotaz cislo:103
SELECT * FROM shop_art2lang WHERE IdArticle = 1822 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:104
SELECT * FROM shop_art2cat WHERE IdArticle = '1822'
select properties of object CShopArt2Cat
Dotaz cislo:105
SELECT * FROM shop_art2serie WHERE IdArticle = '1822'
select properties of object CShopArt2Cat
Dotaz cislo:106
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1822' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:107
SELECT * FROM shop_art2file WHERE IdArticle = '1822' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:108
SELECT * FROM shop_attributes WHERE IdArticle = '1822' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:109
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 494 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:110
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 497 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:111
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:112
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:113
SELECT * FROM shop_anchor WHERE IdArticle = '1822' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:114
SELECT * FROM virtual_directory WHERE IdItem = 1822 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:115
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5462 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:116
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:117
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:118
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1822' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:55:19' AND TimeTo > '2025-07-06 01:55:19' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:119
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1822 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:120
SELECT * FROM shop_article WHERE Id=1830
select properties of object shop article
Dotaz cislo:121
SELECT * FROM shop_art2lang WHERE IdArticle = 1830 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:122
SELECT * FROM shop_art2cat WHERE IdArticle = '1830'
select properties of object CShopArt2Cat
Dotaz cislo:123
SELECT * FROM shop_art2serie WHERE IdArticle = '1830'
select properties of object CShopArt2Cat
Dotaz cislo:124
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1830' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:125
SELECT * FROM shop_art2file WHERE IdArticle = '1830' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:126
SELECT * FROM shop_attributes WHERE IdArticle = '1830' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:127
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 656 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:128
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 674 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:129
SELECT * FROM shop_art2flag WHERE IdArticle = '1830' 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:130
SELECT * FROM shop_art2vat WHERE IdArticle = '1830'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:131
SELECT * FROM shop_anchor WHERE IdArticle = '1830' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:132
SELECT * FROM virtual_directory WHERE IdItem = 1830 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:133
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5470 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:134
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=1830)
nebylo zadano
Dotaz cislo:135
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=1830 OR a.IdParent=1830) AND c.ValueWithVAT>0 ORDER BY c2.Value ASC, c.Value ASC LIMIT 0,1
select vat to article
Dotaz cislo:136
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1830' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:55:19' AND TimeTo > '2025-07-06 01:55:19' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:137
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1830 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:138
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1905
nebylo zadano
Dotaz cislo:139
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:140
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:141
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:142
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:143
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:144
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:145
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:146
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:147
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:148
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:149
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:150
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:151
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:152
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:153
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:154
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:155
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:156
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:157
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:158
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
57,84 €
20%
Das VW auto
: testimport
 
57,84 €
46,27 €
Dotaz cislo:159
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:160
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
In Store
Dotaz cislo:161
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1822
nebylo zadano
Dotaz cislo:162
SELECT * FROM shop_cat_tree WHERE Id=91
select properties of object shop category
Dotaz cislo:163
SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:164
SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:165
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:166
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:167
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
: dph21
 
 
46,66 €
Dotaz cislo:168
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
In Store
Dotaz cislo:169
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1830
nebylo zadano
Dotaz cislo:170
SELECT * FROM shop_cat_tree WHERE Id=92
select properties of object shop category
Dotaz cislo:171
SELECT * FROM shop_cat_tree2lang WHERE IdCat=92 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:172
SELECT * FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:173
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7331 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:174
SELECT * FROM images WHERE Id=924
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:175
SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=200 AND CountTo>=200
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
: ab1830
 
 
11,82 €
Dotaz cislo:176
SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1830'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
In Store

Dotaz cislo:177
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 = 2 AND t2l.Flags & 1 = 1 INNER JOIN shop_interrelated_articles sia ON sia.IdArticle = 1895 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

Dotaz cislo:178
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 = 2 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=2 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=2 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 = 1895 WHERE al.Flags&1 ORDER BY saa.colOrder ASC

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 = 2 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=2 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=2 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 = 1895 WHERE al.Flags&1 ORDER BY saa.colOrder ASC

Dotaz cislo:180
SELECT * FROM shop_article WHERE Id=1829
select properties of object shop article
Dotaz cislo:181
SELECT * FROM shop_art2lang WHERE IdArticle = 1829 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:182
SELECT * FROM shop_art2cat WHERE IdArticle = '1829'
select properties of object CShopArt2Cat
Dotaz cislo:183
SELECT * FROM shop_art2serie WHERE IdArticle = '1829'
select properties of object CShopArt2Cat
Dotaz cislo:184
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1829' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:185
SELECT * FROM shop_art2file WHERE IdArticle = '1829' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:186
SELECT * FROM shop_attributes WHERE IdArticle = '1829' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:187
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 634 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:188
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 640 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:189
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 671 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:190
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:191
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:192
SELECT * FROM shop_anchor WHERE IdArticle = '1829' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:193
SELECT * FROM virtual_directory WHERE IdItem = 1829 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:194
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5469 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:195
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:196
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:197
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1829' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:55:19' AND TimeTo > '2025-07-06 01:55:19' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:198
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1829 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:199
SELECT * FROM shop_article WHERE Id=1828
select properties of object shop article
Dotaz cislo:200
SELECT * FROM shop_art2lang WHERE IdArticle = 1828 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:201
SELECT * FROM shop_art2cat WHERE IdArticle = '1828'
select properties of object CShopArt2Cat
Dotaz cislo:202
SELECT * FROM shop_art2serie WHERE IdArticle = '1828'
select properties of object CShopArt2Cat
Dotaz cislo:203
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1828' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:204
SELECT * FROM shop_art2file WHERE IdArticle = '1828' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:205
SELECT * FROM shop_attributes WHERE IdArticle = '1828' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:206
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 642 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:207
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 673 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:208
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:209
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:210
SELECT * FROM shop_anchor WHERE IdArticle = '1828' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:211
SELECT * FROM virtual_directory WHERE IdItem = 1828 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:212
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5468 AND IdLanguage=2
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=1828)
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=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:215
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1828' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:55:19' AND TimeTo > '2025-07-06 01:55:19' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:216
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1828 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:217
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1829
nebylo zadano
Dotaz cislo:218
SELECT * FROM shop_cat_tree WHERE Id=92
select properties of object shop category
Dotaz cislo:219
SELECT * FROM shop_cat_tree2lang WHERE IdCat=92 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:220
SELECT * FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:221
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7331 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:222
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:223
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:224
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:225
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:226
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
: ab1829
 
 
11,82 €
Dotaz cislo:227
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:228
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
In Store
Dotaz cislo:229
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1828
nebylo zadano
Dotaz cislo:230
SELECT * FROM shop_cat_tree WHERE Id=92
select properties of object shop category
Dotaz cislo:231
SELECT * FROM shop_cat_tree2lang WHERE IdCat=92 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:232
SELECT * FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:233
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7331 AND IdLanguage=1
select properties of object virtual_directory2lang
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_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
: ab1828
 
 
11,82 €
Dotaz cislo:236
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
In Store
Dotaz cislo:237
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=3 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:238
SELECT * FROM security_user2group WHERE IdUser=3
select groups of security_user

-

Jméno Příjmení
phone +420 777 721 282
Dotaz cislo:272
call getRightsForUser(2, 34)
load rights
Dotaz cislo:273
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=2 WHERE v.IdItem=169 AND v.IdSecuritySection = 1
select id of inserted virtual_directory from db