| Queries |
|---|
| 0.000131 - SET NAMES 'utf8' |
| 0.000052 - SET SQL_BIG_SELECTS = 1 |
| 0.000105 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
| 0.000270 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '12605075193d769eefbc467eee8b165f' |
| 0.000261 - SELECT * FROM modules WHERE dirname = 'adslight' |
| 0.006019 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '5') |
| 0.011508 - SELECT * FROM config WHERE (conf_modid = '5') ORDER BY conf_order ASC |
| 0.000287 - SELECT * FROM modules WHERE dirname = 'protector' |
| 0.001299 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '5' AND (gperm_groupid = '3') AND gperm_name = 'adslight_view') |
| 0.000534 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '5' AND (gperm_groupid = '3') AND gperm_name = 'adslight_premium') |
| 0.000183 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC |
| 0.000157 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
| 0.157470 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,5) AND b.bid IN (20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,21,22,23,24,25,26,27,28,29,30,31) ORDER BY b.weight, m.block_id |
| 0.000242 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_login.html') ORDER BY tpl_refid |
| 0.000048 - SELECT COUNT(*) FROM modules WHERE dirname = 'news' |
| 0.000049 - SELECT COUNT(*) FROM modules WHERE dirname = 'mylinks' |
| 0.000035 - SELECT COUNT(*) FROM modules WHERE dirname = 'mydownloads' |
| 0.000037 - SELECT COUNT(*) FROM xoopscomments WHERE com_status=1 |
| 0.000044 - SELECT COUNT(*) FROM modules WHERE dirname = 'TDMDownloads' |
| 0.000041 - SELECT COUNT(*) FROM modules WHERE dirname = 'extgallery' |
| 0.000053 - SELECT COUNT(*) FROM modules WHERE dirname = 'smartsection' |
| 0.000090 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_waiting.html') ORDER BY tpl_refid |
| 0.000116 - SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC |
| 0.000059 - SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND gperm_groupid = '3') |
| 0.000172 - SELECT * FROM modules WHERE dirname = 'xnews' |
| 0.000144 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '8' AND (gperm_groupid = '3') AND gperm_name = 'nw_submit') |
| 0.000167 - SELECT * FROM config WHERE (conf_modid = '8') ORDER BY conf_order ASC |
| 0.000156 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid |
| 0.047698 - SELECT COUNT(*) FROM banner |
| 0.000447 - SELECT * FROM banner LIMIT 0, 1 |
| 0.000162 - UPDATE banner SET impmade = 3572 WHERE bid = 1 |
| 0.035183 - select lid, title, expire, type, desctext, date, email, submitter, photo, photo2, photo3, valid, hits, comments, remind FROM adslight_listing WHERE valid='Yes' |
| 0.000135 - select SQL_CACHE COUNT(*) FROM adslight_listing WHERE valid="No" |
| 0.001103 - SELECT * FROM group_permission WHERE (gperm_name = 'adslight_view' AND gperm_modid = '5' AND gperm_groupid = '3') |
| 0.001729 - SELECT SQL_CACHE cid, title, img FROM adslight_categories WHERE pid = 0 AND cid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000158 - select SQL_CACHE count(*) from adslight_listing where cid=28 and valid='Yes' and status!='1' |
| 0.000195 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=28 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000193 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=29 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000175 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=30 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000176 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=31 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000170 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=32 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000123 - select SQL_CACHE count(*) from adslight_listing where cid=29 and valid='Yes' and status!='1' |
| 0.000122 - select SQL_CACHE count(*) from adslight_listing where cid=30 and valid='Yes' and status!='1' |
| 0.000118 - select SQL_CACHE count(*) from adslight_listing where cid=31 and valid='Yes' and status!='1' |
| 0.000118 - select SQL_CACHE count(*) from adslight_listing where cid=32 and valid='Yes' and status!='1' |
| 0.000231 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=28 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000131 - select SQL_CACHE count(*) from adslight_listing where cid=1 and valid='Yes' and status!='1' |
| 0.000179 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=1 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000171 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=4 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000174 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=5 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000218 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=6 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000162 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=7 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000149 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=8 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000099 - select SQL_CACHE count(*) from adslight_listing where cid=4 and valid='Yes' and status!='1' |
| 0.000098 - select SQL_CACHE count(*) from adslight_listing where cid=5 and valid='Yes' and status!='1' |
| 0.000184 - select SQL_CACHE count(*) from adslight_listing where cid=6 and valid='Yes' and status!='1' |
| 0.000260 - select SQL_CACHE count(*) from adslight_listing where cid=7 and valid='Yes' and status!='1' |
| 0.000113 - select SQL_CACHE count(*) from adslight_listing where cid=8 and valid='Yes' and status!='1' |
| 0.000210 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=1 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000114 - select SQL_CACHE count(*) from adslight_listing where cid=16 and valid='Yes' and status!='1' |
| 0.000154 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=16 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000159 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=23 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000507 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=24 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000169 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=25 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000152 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=26 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000103 - select SQL_CACHE count(*) from adslight_listing where cid=23 and valid='Yes' and status!='1' |
| 0.000097 - select SQL_CACHE count(*) from adslight_listing where cid=24 and valid='Yes' and status!='1' |
| 0.000091 - select SQL_CACHE count(*) from adslight_listing where cid=25 and valid='Yes' and status!='1' |
| 0.000100 - select SQL_CACHE count(*) from adslight_listing where cid=26 and valid='Yes' and status!='1' |
| 0.000202 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=16 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000107 - select SQL_CACHE count(*) from adslight_listing where cid=3 and valid='Yes' and status!='1' |
| 0.000152 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=3 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000154 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=14 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000156 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=15 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000231 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=27 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000101 - select SQL_CACHE count(*) from adslight_listing where cid=14 and valid='Yes' and status!='1' |
| 0.000095 - select SQL_CACHE count(*) from adslight_listing where cid=15 and valid='Yes' and status!='1' |
| 0.000158 - select SQL_CACHE count(*) from adslight_listing where cid=27 and valid='Yes' and status!='1' |
| 0.000197 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=3 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000114 - select SQL_CACHE count(*) from adslight_listing where cid=19 and valid='Yes' and status!='1' |
| 0.000156 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=19 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000154 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=20 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000161 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=21 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000157 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=22 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000101 - select SQL_CACHE count(*) from adslight_listing where cid=20 and valid='Yes' and status!='1' |
| 0.000159 - select SQL_CACHE count(*) from adslight_listing where cid=21 and valid='Yes' and status!='1' |
| 0.000105 - select SQL_CACHE count(*) from adslight_listing where cid=22 and valid='Yes' and status!='1' |
| 0.000200 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=19 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000341 - select SQL_CACHE count(*) from adslight_listing where cid=2 and valid='Yes' and status!='1' |
| 0.000164 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=2 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000171 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=9 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000175 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=10 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000156 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=11 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000147 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=12 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000151 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=13 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000103 - select SQL_CACHE count(*) from adslight_listing where cid=9 and valid='Yes' and status!='1' |
| 0.000240 - select SQL_CACHE count(*) from adslight_listing where cid=10 and valid='Yes' and status!='1' |
| 0.000101 - select SQL_CACHE count(*) from adslight_listing where cid=11 and valid='Yes' and status!='1' |
| 0.000097 - select SQL_CACHE count(*) from adslight_listing where cid=12 and valid='Yes' and status!='1' |
| 0.000094 - select SQL_CACHE count(*) from adslight_listing where cid=13 and valid='Yes' and status!='1' |
| 0.000215 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=2 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000126 - select SQL_CACHE count(*) from adslight_listing where cid=18 and valid='Yes' and status!='1' |
| 0.000158 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=18 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000154 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=33 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000148 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=34 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000155 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=35 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000155 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=36 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000159 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=37 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000103 - select SQL_CACHE count(*) from adslight_listing where cid=33 and valid='Yes' and status!='1' |
| 0.000100 - select SQL_CACHE count(*) from adslight_listing where cid=34 and valid='Yes' and status!='1' |
| 0.000102 - select SQL_CACHE count(*) from adslight_listing where cid=35 and valid='Yes' and status!='1' |
| 0.000102 - select SQL_CACHE count(*) from adslight_listing where cid=36 and valid='Yes' and status!='1' |
| 0.000097 - select SQL_CACHE count(*) from adslight_listing where cid=37 and valid='Yes' and status!='1' |
| 0.000210 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=18 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000108 - select SQL_CACHE count(*) from adslight_listing where cid=17 and valid='Yes' and status!='1' |
| 0.000162 - SELECT SQL_CACHE cid FROM adslight_categories WHERE pid=17 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000187 - SELECT SQL_CACHE * FROM adslight_categories WHERE pid=17 AND pid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY title |
| 0.000139 - select SQL_CACHE COUNT(*) FROM adslight_listing WHERE valid='Yes' AND status!='1' AND cid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) |
| 0.000103 - select COUNT(*) FROM adslight_categories |
| 0.000796 - SELECT * FROM group_permission WHERE (gperm_name = 'adslight_submit' AND gperm_modid = '5' AND gperm_groupid = '3') |
| 0.000187 - select SQL_CACHE lid, title, status, type, price, typeprice, date, town, country, usid, premium, valid, photo, hits from adslight_listing WHERE valid='Yes' and status!='1' AND cid IN (1,4,5,6,7,8,2,9,10,11,12,13,3,14,15,27,16,23,24,25,26,17,18,33,34,35,36,37,19,20,21,22,28,29,30,31,32) ORDER BY date DESC LIMIT 10 |
| 0.038263 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'adslight_index.html') ORDER BY tpl_refid |
| 0.006997 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'adslight_menu.html') ORDER BY tpl_refid |
| 0.000190 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid |