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:52
SELECT * FROM shop_producer2lang WHERE IdProducer = '14'
select properties of object shop_search2art_cat
AiVisionDotaz cislo:54
SELECT * FROM shop_producer2lang WHERE IdProducer = '17'
select properties of object shop_search2art_cat
Dotaz cislo:55
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:58
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:60
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 section WHERE Id=103
select properties of object section
Dotaz cislo:27
SELECT * FROM section_sec2lang WHERE IdSection=103 AND IdLanguage=1
select properties of object section_sec2lang