SELECT DISTINCT t.Id, t2l.Name, t.Color FROM shop_cat_tree t INNER JOIN shop_cat_tree2lang t2l ON t2l.IdCat = t.Id AND t2l.IdLanguage = 2 AND (t2l.Flags & 1) AND (t2l.Flags & 8) LEFT JOIN shop_cat2img t2i ON t2i.IdCategory = t.Id ORDER BY t.colOrder
fulltext in shop cats
Dotaz cislo:27
SELECT * FROM shop_cat2img WHERE (1=1) AND IdCategory = '410' AND Flags & '4' 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:28
SELECT * FROM images WHERE Id=1501
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:29
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=410 AND v.IdSecuritySection = 16
select id of inserted virtual_directory from db
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 4194304, '', 0, 99993, 1 /*smer razeni*/, true, true, 0, 0, 2, 1);
nebylo zadano
Dotaz cislo:31
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 4194304, '', 0, 99993, 1 /*smer razeni*/, true, true, 0, 4, 1, 1);
function DoSql() in PAGING file pag.php
-
Dotaz cislo:32
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1827
nebylo zadano
Dotaz cislo:33
SELECT * FROM shop_cat_tree WHERE Id=92
select properties of object shop category
Dotaz cislo:34
SELECT * FROM shop_cat_tree2lang WHERE IdCat=92 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:35
SELECT * FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:36
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7331 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:37
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:38
SELECT * FROM images WHERE Id=925
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:39
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:40
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:41
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:44
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1822
nebylo zadano
Dotaz cislo:45
SELECT * FROM shop_cat_tree WHERE Id=91
select properties of object shop category
Dotaz cislo:46
SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:47
SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:48
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:49
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:50
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:51
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:52
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
Dotaz cislo:67
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1821
nebylo zadano
Dotaz cislo:68
SELECT * FROM shop_cat_tree WHERE Id=91
select properties of object shop category
Dotaz cislo:69
SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:70
SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:71
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:72
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:73
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:74
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:75
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:76
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:77
SELECT * FROM virtual_directory WHERE IdItem = 16 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:78
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7408 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:79
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
select properties of object virtual_directpry_set
Dotaz cislo:80
SELECT * FROM virtual_directory WHERE Id=7408
select properties of object virtual_directory
Dotaz cislo:81
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7408
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:82
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
select properties of object virtual_directpry_set
Dotaz cislo:83
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:84
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:86
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1817
nebylo zadano
Dotaz cislo:87
SELECT * FROM shop_cat_tree WHERE Id=89
select properties of object shop category
Dotaz cislo:88
SELECT * FROM shop_cat_tree2lang WHERE IdCat=89 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:89
SELECT * FROM virtual_directory WHERE IdItem = 89 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:90
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7400 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:91
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:92
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:93
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:94
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:95
SELECT * FROM images WHERE Id=906
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:96
SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=77 AND CountTo>=77
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
SELECT * FROM section WHERE Id=249
select properties of object section
Dotaz cislo:99
SELECT * FROM section_sec2lang WHERE IdSection=249 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:100
call getRightsForUser(2, 36)
load rights
SELECT * FROM section WHERE Id=251
select properties of object section
Dotaz cislo:102
SELECT * FROM section_sec2lang WHERE IdSection=251 AND IdLanguage=2
select properties of object section_sec2lang
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 128, '', 0, 0, 0 /*smer razeni*/, true, true, 0, 0, 2, 1);
nebylo zadano
Dotaz cislo:104
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 128, '', 0, 0, 0 /*smer razeni*/, true, true, 0, 4, 1, 1);
function DoSql() in PAGING file pag.php
-
Dotaz cislo:105
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1814
nebylo zadano
Dotaz cislo:106
SELECT * FROM shop_cat_tree WHERE Id=90
select properties of object shop category
Dotaz cislo:107
SELECT * FROM shop_cat_tree2lang WHERE IdCat=90 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:108
SELECT * FROM virtual_directory WHERE IdItem = 90 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:109
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7389 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:110
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:111
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:112
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:113
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:114
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:115
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:116
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:117
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:118
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:119
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:120
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:121
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:122
SELECT * FROM images WHERE Id=903
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:123
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:124
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:125
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
Dotaz cislo:128
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1813
nebylo zadano
Dotaz cislo:129
SELECT * FROM shop_cat_tree WHERE Id=90
select properties of object shop category
Dotaz cislo:130
SELECT * FROM shop_cat_tree2lang WHERE IdCat=90 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:131
SELECT * FROM virtual_directory WHERE IdItem = 90 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:132
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7389 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:133
SELECT * FROM images WHERE Id=901
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:134
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:135
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:136
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:139
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1931
nebylo zadano
Dotaz cislo:140
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:141
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:142
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:143
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:144
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:145
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:146
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:147
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:148
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:149
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:150
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:151
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:152
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:153
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:154
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:155
SELECT * FROM images WHERE Id=1099
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_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:158
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1930
nebylo zadano
Dotaz cislo:159
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:160
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:161
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:162
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:163
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:164
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:165
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:166
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:167
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:168
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:169
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:170
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:171
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:172
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:173
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:174
SELECT * FROM images WHERE Id=1098
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=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
SELECT * FROM section WHERE Id=262
select properties of object section
Dotaz cislo:178
SELECT * FROM section_sec2lang WHERE IdSection=262 AND IdLanguage=2
select properties of object section_sec2lang
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 = 2 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=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 WHERE al.Flags&1 GROUP BY IFNULL(a.IdParent, a.Id) ORDER BY Cnt DESC, a.Id DESC LIMIT 0, 10
Dotaz cislo:180
SELECT * FROM shop_article WHERE Id=1905
select properties of object shop article
Dotaz cislo:181
SELECT * FROM shop_art2lang WHERE IdArticle = 1905 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:182
SELECT * FROM shop_art2cat WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:183
SELECT * FROM shop_art2serie WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:184
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1905' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:185
SELECT * FROM shop_art2file WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:186
SELECT * FROM shop_attributes WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:187
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 580 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:188
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 583 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:189
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 581 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:190
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 635 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:191
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:192
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:193
SELECT * FROM shop_anchor WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:194
SELECT * FROM shop_anchor2lang WHERE IdAnchor=1 AND IdLanguage=2
select properties of object shop_attributes2lang
Dotaz cislo:195
SELECT * FROM virtual_directory WHERE IdItem = 1905 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:196
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5627 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:197
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:198
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:199
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1905' AND IdCostType = '3' AND TimeFrom < '2025-07-05 21:55:07' AND TimeTo > '2025-07-05 21:55:07' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:200
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:201
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1905 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:202
SELECT * FROM shop_article WHERE Id=1821
select properties of object shop article
Dotaz cislo:203
SELECT * FROM shop_art2lang WHERE IdArticle = 1821 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:204
SELECT * FROM shop_art2cat WHERE IdArticle = '1821'
select properties of object CShopArt2Cat
Dotaz cislo:205
SELECT * FROM shop_art2serie WHERE IdArticle = '1821'
select properties of object CShopArt2Cat
Dotaz cislo:206
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1821' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:207
SELECT * FROM shop_art2file WHERE IdArticle = '1821' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:208
SELECT * FROM shop_attributes WHERE IdArticle = '1821' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:209
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:210
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:211
SELECT * FROM shop_anchor WHERE IdArticle = '1821' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:212
SELECT * FROM virtual_directory WHERE IdItem = 1821 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:213
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5461 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:214
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:215
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:216
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1821' AND IdCostType = '3' AND TimeFrom < '2025-07-05 21:55:07' AND TimeTo > '2025-07-05 21:55:07' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:217
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1821 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:218
SELECT * FROM shop_article WHERE Id=1817
select properties of object shop article
Dotaz cislo:219
SELECT * FROM shop_art2lang WHERE IdArticle = 1817 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:220
SELECT * FROM shop_art2cat WHERE IdArticle = '1817'
select properties of object CShopArt2Cat
Dotaz cislo:221
SELECT * FROM shop_art2serie WHERE IdArticle = '1817'
select properties of object CShopArt2Cat
Dotaz cislo:222
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1817' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:223
SELECT * FROM shop_art2file WHERE IdArticle = '1817' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:224
SELECT * FROM shop_attributes WHERE IdArticle = '1817' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:225
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 668 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:226
SELECT * FROM shop_art2flag WHERE IdArticle = '1817' 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:227
SELECT * FROM shop_art2vat WHERE IdArticle = '1817'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:228
SELECT * FROM shop_anchor WHERE IdArticle = '1817' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:229
SELECT * FROM virtual_directory WHERE IdItem = 1817 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:230
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5457 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:231
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=1817)
nebylo zadano
Dotaz cislo:232
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=1817 OR a.IdParent=1817) AND c.ValueWithVAT>0 ORDER BY c2.Value ASC, c.Value ASC LIMIT 0,1
select vat to article
Dotaz cislo:233
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1817' AND IdCostType = '3' AND TimeFrom < '2025-07-05 21:55:07' AND TimeTo > '2025-07-05 21:55:07' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:234
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1817 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
-
Dotaz cislo:235
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1905
nebylo zadano
Dotaz cislo:236
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:237
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:238
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:239
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:240
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:241
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:242
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:243
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:244
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:245
SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:246
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:247
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:248
SELECT * FROM virtual_directory WHERE Id=7356
select properties of object virtual_directory
Dotaz cislo:249
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:250
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
select properties of object virtual_directpry_set
Dotaz cislo:251
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:252
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:253
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:254
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:255
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
Dotaz cislo:270
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1821
nebylo zadano
Dotaz cislo:271
SELECT * FROM shop_cat_tree WHERE Id=91
select properties of object shop category
Dotaz cislo:272
SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:273
SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:274
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:275
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:276
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:277
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:278
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:279
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:280
SELECT * FROM virtual_directory WHERE IdItem = 16 AND IdSecuritySection = 65
select properties of object VirtualDirectory::=Get
Dotaz cislo:281
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7408 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:282
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
select properties of object virtual_directpry_set
Dotaz cislo:283
SELECT * FROM virtual_directory WHERE Id=7408
select properties of object virtual_directory
Dotaz cislo:284
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7408
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:285
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
select properties of object virtual_directpry_set
Dotaz cislo:286
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:287
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:288
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:289
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:293
SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1817
nebylo zadano
Dotaz cislo:294
SELECT * FROM shop_cat_tree WHERE Id=89
select properties of object shop category
Dotaz cislo:295
SELECT * FROM shop_cat_tree2lang WHERE IdCat=89 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:296
SELECT * FROM virtual_directory WHERE IdItem = 89 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:297
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7400 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:298
SELECT * FROM shop_cat_tree WHERE Id=87
select properties of object shop category
Dotaz cislo:299
SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
select properties of object shop_cat_tree2lang
Dotaz cislo:300
SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
select properties of object VirtualDirectory::=Get
Dotaz cislo:301
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:302
SELECT * FROM images WHERE Id=906
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:303
SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=77 AND CountTo>=77
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
call getRightsForUser(2, 18)
load rights
SELECT DISTINCT news.*, n2l.*, DATE_FORMAT(news.Date,'%d.%m.%Y') as date, i.Filename, i.isBig, i.Alt FROM news INNER JOIN news2lang n2l ON n2l.IdNews = news.Id AND n2l.IdLanguage = 2 AND n2l.Flags & 1 INNER JOIN news2cat c ON c.IdNews=news.Id LEFT JOIN images i ON i.Id=news.IdImage WHERE 1=1 AND now() < DateTo AND now() > DateFrom AND news.Flags & 1 ORDER BY news.Date DESC LIMIT 4
selct news from db
call getRightsForUser(2, 17)
load rights
SELECT * FROM shop_heureka WHERE (1=1) AND Flags & 1 AND (Plus<>'' OR Minus<>'' OR Summary<>'') ORDER BY Inserted DESC LIMIT 4
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsHeurekaOvereno.php on line 870 in method CShopHeureka::get
SELECT * FROM section WHERE Id=224
select properties of object section
Dotaz cislo:311
SELECT * FROM section_sec2lang WHERE IdSection=224 AND IdLanguage=2
select properties of object section_sec2lang
SELECT * FROM section WHERE Id=266
select properties of object section
Dotaz cislo:313
SELECT * FROM section_sec2lang WHERE IdSection=266 AND IdLanguage=2
select properties of object section_sec2lang