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:142
SELECT * FROM shop_producer2lang WHERE IdProducer = '14'
select properties of object shop_search2art_cat
AiVisionDotaz cislo:144
SELECT * FROM shop_producer2lang WHERE IdProducer = '17'
select properties of object shop_search2art_cat
Dotaz cislo:145
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:148
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:150
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
call getRightsForUser(2, 30)
load rights
Dotaz cislo:27
SELECT * FROM gallery_tree g INNER JOIN gallery_tree2lang g2l ON g.Id=g2l.IdCat WHERE g2l.IdCat=11 AND g2l.IdLanguage=1
Dotaz cislo:28
SELECT count(*) as cnt FROM gallery_tree WHERE IdParent = 11
select count of child galleries
SELECT kat2.Name as nazev, kat1.IdParent as idParent, kat1.Id as id, 1 as ShowItem FROM gallery_tree kat1 INNER JOIN gallery_tree2lang kat2 ON kat2.IdCat = kat1.Id WHERE kat1.Id = 11 AND IdLanguage = 1 AND kat2.Flags&1 GROUP BY idParent ORDER BY nazev
kategorie_v ceste CWriteTreePath
Dotaz cislo:30
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=11 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:31
SELECT kat2.Name as nazev, kat1.IdParent as idParent, kat1.Id as id, 1 as ShowItem FROM gallery_tree kat1 INNER JOIN gallery_tree2lang kat2 ON kat2.IdCat = kat1.Id WHERE kat1.Id = 8 AND IdLanguage = 1 AND kat2.Flags&1 GROUP BY idParent ORDER BY nazev
kategorie_v ceste CWriteTreePath
Dotaz cislo:32
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=8 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Výrobky
SELECT gp.*, gp2l.* FROM gallery_pictures gp INNER JOIN gallery_pictures2lang gp2l ON gp2l.IdImage = gp.Id AND gp2l.IdLanguage = 1 WHERE 1=1 AND gp.IdCat = 11 ORDER BY gp.colOrder DESC LIMIT 16
selct news from db
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=284 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:35
SELECT * FROM gallery_pictures WHERE Id=284
select filename of files to delete him
Dotaz cislo:36
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:37
SELECT * FROM gallery_pictures2lang WHERE IdImage=284 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:38
SELECT * FROM gallery_pictures2lang WHERE IdImage=284 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:39
SELECT * FROM gallery_pictures2lang WHERE IdImage=284 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:40
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=272 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:41
SELECT * FROM gallery_pictures WHERE Id=272
select filename of files to delete him
Dotaz cislo:42
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:43
SELECT * FROM gallery_pictures2lang WHERE IdImage=272 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:44
SELECT * FROM gallery_pictures2lang WHERE IdImage=272 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:45
SELECT * FROM gallery_pictures2lang WHERE IdImage=272 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:46
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=271 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:47
SELECT * FROM gallery_pictures WHERE Id=271
select filename of files to delete him
Dotaz cislo:48
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:49
SELECT * FROM gallery_pictures2lang WHERE IdImage=271 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:50
SELECT * FROM gallery_pictures2lang WHERE IdImage=271 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:51
SELECT * FROM gallery_pictures2lang WHERE IdImage=271 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:52
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=270 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:53
SELECT * FROM gallery_pictures WHERE Id=270
select filename of files to delete him
Dotaz cislo:54
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:55
SELECT * FROM gallery_pictures2lang WHERE IdImage=270 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:56
SELECT * FROM gallery_pictures2lang WHERE IdImage=270 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:57
SELECT * FROM gallery_pictures2lang WHERE IdImage=270 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:58
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=269 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:59
SELECT * FROM gallery_pictures WHERE Id=269
select filename of files to delete him
Dotaz cislo:60
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:61
SELECT * FROM gallery_pictures2lang WHERE IdImage=269 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:62
SELECT * FROM gallery_pictures2lang WHERE IdImage=269 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:63
SELECT * FROM gallery_pictures2lang WHERE IdImage=269 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:64
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=268 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:65
SELECT * FROM gallery_pictures WHERE Id=268
select filename of files to delete him
Dotaz cislo:66
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:67
SELECT * FROM gallery_pictures2lang WHERE IdImage=268 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:68
SELECT * FROM gallery_pictures2lang WHERE IdImage=268 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:69
SELECT * FROM gallery_pictures2lang WHERE IdImage=268 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:70
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=267 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:71
SELECT * FROM gallery_pictures WHERE Id=267
select filename of files to delete him
Dotaz cislo:72
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:73
SELECT * FROM gallery_pictures2lang WHERE IdImage=267 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:74
SELECT * FROM gallery_pictures2lang WHERE IdImage=267 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:75
SELECT * FROM gallery_pictures2lang WHERE IdImage=267 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:76
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=266 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:77
SELECT * FROM gallery_pictures WHERE Id=266
select filename of files to delete him
Dotaz cislo:78
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:79
SELECT * FROM gallery_pictures2lang WHERE IdImage=266 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:80
SELECT * FROM gallery_pictures2lang WHERE IdImage=266 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:81
SELECT * FROM gallery_pictures2lang WHERE IdImage=266 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:82
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=265 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:83
SELECT * FROM gallery_pictures WHERE Id=265
select filename of files to delete him
Dotaz cislo:84
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:85
SELECT * FROM gallery_pictures2lang WHERE IdImage=265 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:86
SELECT * FROM gallery_pictures2lang WHERE IdImage=265 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:87
SELECT * FROM gallery_pictures2lang WHERE IdImage=265 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:88
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=264 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:89
SELECT * FROM gallery_pictures WHERE Id=264
select filename of files to delete him
Dotaz cislo:90
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:91
SELECT * FROM gallery_pictures2lang WHERE IdImage=264 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:92
SELECT * FROM gallery_pictures2lang WHERE IdImage=264 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:93
SELECT * FROM gallery_pictures2lang WHERE IdImage=264 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:94
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=263 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:95
SELECT * FROM gallery_pictures WHERE Id=263
select filename of files to delete him
Dotaz cislo:96
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:97
SELECT * FROM gallery_pictures2lang WHERE IdImage=263 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:98
SELECT * FROM gallery_pictures2lang WHERE IdImage=263 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:99
SELECT * FROM gallery_pictures2lang WHERE IdImage=263 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:100
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=262 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:101
SELECT * FROM gallery_pictures WHERE Id=262
select filename of files to delete him
Dotaz cislo:102
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:103
SELECT * FROM gallery_pictures2lang WHERE IdImage=262 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:104
SELECT * FROM gallery_pictures2lang WHERE IdImage=262 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:105
SELECT * FROM gallery_pictures2lang WHERE IdImage=262 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:106
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=261 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:107
SELECT * FROM gallery_pictures WHERE Id=261
select filename of files to delete him
Dotaz cislo:108
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:109
SELECT * FROM gallery_pictures2lang WHERE IdImage=261 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:110
SELECT * FROM gallery_pictures2lang WHERE IdImage=261 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:111
SELECT * FROM gallery_pictures2lang WHERE IdImage=261 AND IdLanguage=5
select properties of object gallery_pictures2lang
Dotaz cislo:112
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=260 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:113
SELECT * FROM gallery_pictures WHERE Id=260
select filename of files to delete him
Dotaz cislo:114
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:115
SELECT * FROM gallery_pictures2lang WHERE IdImage=260 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:116
SELECT * FROM gallery_pictures2lang WHERE IdImage=260 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:117
SELECT * FROM gallery_pictures2lang WHERE IdImage=260 AND IdLanguage=5
select properties of object gallery_pictures2lang