SELECT c.Id, c2l.Name, vd2l.Name as Url, count(child.IdParent) as cntChild, c.IdParent, parent.IdParent as IdParentParent , img.Filename, c.Color FROM shop_cat_tree c INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.IdLanguage=1 AND (c2l.Flags & 1) INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND vd.IdItem=c.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id=vd2l.IdDirectory AND vd2l.IdLanguage=1 LEFT JOIN shop_cat_tree parent ON c.IdParent=parent.Id LEFT JOIN shop_cat_tree child ON c.Id=child.IdParent LEFT JOIN shop_cat2img c2img ON c.Id=c2img.IdCategory AND (c2img.Flags & 4) LEFT JOIN images img ON c2img.IdImage=img.Id WHERE c.IdParent=110 GROUP BY c.Id ORDER BY c.colOrder
Dotaz cislo:126
SELECT IdParent FROM shop_cat_tree WHERE Id=110
Dotaz cislo:127
SELECT c.Id, c2l.Name, vd2l.Name as Url, count(child.IdParent) as cntChild, c.IdParent, parent.IdParent as IdParentParent , img.Filename, c.Color FROM shop_cat_tree c INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.IdLanguage=1 AND (c2l.Flags & 1) INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND vd.IdItem=c.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id=vd2l.IdDirectory AND vd2l.IdLanguage=1 LEFT JOIN shop_cat_tree parent ON c.IdParent=parent.Id LEFT JOIN shop_cat_tree child ON c.Id=child.IdParent LEFT JOIN shop_cat2img c2img ON c.Id=c2img.IdCategory AND (c2img.Flags & 4) LEFT JOIN images img ON c2img.IdImage=img.Id WHERE c.IdParent=108 GROUP BY c.Id ORDER BY c.colOrder
Dotaz cislo:128
SELECT IdParent FROM shop_cat_tree WHERE Id=108
Dotaz cislo:129
SELECT c.Id, c2l.Name, vd2l.Name as Url, count(child.IdParent) as cntChild, c.IdParent, parent.IdParent as IdParentParent , img.Filename, c.Color FROM shop_cat_tree c INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.IdLanguage=1 AND (c2l.Flags & 1) INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND vd.IdItem=c.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id=vd2l.IdDirectory AND vd2l.IdLanguage=1 LEFT JOIN shop_cat_tree parent ON c.IdParent=parent.Id LEFT JOIN shop_cat_tree child ON c.Id=child.IdParent LEFT JOIN shop_cat2img c2img ON c.Id=c2img.IdCategory AND (c2img.Flags & 4) LEFT JOIN images img ON c2img.IdImage=img.Id WHERE c.IdParent=0 GROUP BY c.Id ORDER BY c.colOrder
SELECT t1.*, t2.* FROM shop_producer t1 INNER JOIN shop_producer2lang t2 ON t2.IdProducer = t1.Id AND t2.IdLanguage = 1 ORDER BY t2.Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 322 in method CShopProducer::get
Dotaz cislo:131
SELECT * FROM shop_producer2lang WHERE IdProducer = '14'
select properties of object shop_search2art_cat
AiVisionDotaz cislo:133
SELECT * FROM shop_producer2lang WHERE IdProducer = '17'
select properties of object shop_search2art_cat
Dotaz cislo:134
SELECT * FROM shop_producer2lang WHERE IdProducer = '16'
select properties of object shop_search2art_cat
Shenzhen Jumaoyuan Science And Technology Co.,Ltd.
SELECT * FROM section WHERE Id=201
select properties of object section
Dotaz cislo:141
SELECT * FROM section_sec2lang WHERE IdSection=201 AND IdLanguage=1
select properties of object section_sec2lang
SELECT * FROM section WHERE Id=17
select properties of object section
Dotaz cislo:143
SELECT * FROM section_sec2lang WHERE IdSection=17 AND IdLanguage=1
select properties of object section_sec2lang
AIVision, s.r.o.
Veverkova 731/19
170 00 Praha 7
IČO: 27131955
DIČ: CZ27131955
+420 233 370 498
+420 608 224 380
SELECT * FROM template_module_variables v WHERE v.IdModule=25
select properties of object CTemplate_Container2Css
Dotaz cislo:27
SELECT * FROM shop_cat_tree WHERE Id=110
select properties of object shop category
Dotaz cislo:28
SELECT * FROM shop_cat_tree2lang WHERE IdCat=110 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:29
SELECT * FROM virtual_directory WHERE IdItem = 110 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:30
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7398 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:31
call sp_shop_article_list_subarticles( 1, false, 1, 2, 1, 0, 0.00, 0.00, 110, '0', '0', '0', 132, 0, 0, '', 0, '', 0, 99990, 0 /*smer razeni*/, true, true, 0, 0, 2, 1);
nebylo zadano
Dotaz cislo:32
call sp_shop_article_list_subarticles( 1, false, 1, 2, 1, 0, 0.00, 0.00, 110, '0', '0', '0', 132, 0, 0, '', 0, '', 0, 99990, 0 /*smer razeni*/, true, true, 0, 4, 1, 1);
function DoSql() in PAGING file pag.php
SELECT * FROM shop_cat2img WHERE (1=1) AND IdCategory = '110' AND Flags & '1' ORDER BY colOrder
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopCat.php on line 1388 in method CShopCat2Img::get
Dotaz cislo:34
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 = 110 AND IdLanguage = 1 AND kat2.Flags&1 GROUP BY idParent ORDER BY nazev
kategorie_v ceste CWriteTreePath
Dotaz cislo:35
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=110 AND v.IdSecuritySection = 16
select id of inserted virtual_directory from db
Dotaz cislo:36
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 = 108 AND IdLanguage = 1 AND kat2.Flags&1 GROUP BY idParent ORDER BY nazev
kategorie_v ceste CWriteTreePath
Dotaz cislo:37
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=108 AND v.IdSecuritySection = 16
select id of inserted virtual_directory from db
Dotaz cislo:38
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 LEFT JOIN shop_cat2img t2i ON t2i.IdCategory = t.Id WHERE t.IdParent = 110 ORDER BY t.colOrder
fulltext in shop cats
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1944
nebylo zadano
Dotaz cislo:40
SELECT * FROM shop_cat_tree WHERE Id=108
select properties of object shop category
Dotaz cislo:41
SELECT * FROM shop_cat_tree2lang WHERE IdCat=108 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:42
SELECT * FROM virtual_directory WHERE IdItem = 108 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:43
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7350 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:44
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:45
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:46
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:47
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:48
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:49
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:50
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:51
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:52
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:53
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:54
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:55
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:56
SELECT * FROM images WHERE Id=1084
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:57
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:58
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:59
SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=250 AND CountTo>=250
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
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

SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1944'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1943
nebylo zadano
Dotaz cislo:63
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:64
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:65
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:66
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:67
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:68
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:69
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:70
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:71
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:72
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:73
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:74
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:75
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:76
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:77
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:78
SELECT * FROM images WHERE Id=1087
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:79
SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=248 AND CountTo>=248
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue

SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1943'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1945
nebylo zadano
Dotaz cislo:82
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:83
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:84
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:85
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:86
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:87
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:88
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:89
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:90
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:91
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:92
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:93
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:94
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:95
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:96
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:97
SELECT * FROM images WHERE Id=1088
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:98
SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=250 AND CountTo>=250
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue

SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1945'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
SELECT * FROM section WHERE Id=229
select properties of object section
Dotaz cislo:101
SELECT * FROM section_sec2lang WHERE IdSection=229 AND IdLanguage=1
select properties of object section_sec2lang
Dotaz cislo:102
call getRightsForUser(2, 36)
load rights