Menu Content
Media Reel

  |  Print  

 

73 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT `id`,`link` FROM jos_menu WHERE ((`name` LIKE '%Footer%') AND (`published` > 0))
4 SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Footer/Press/' ORDER BY rank ASC LIMIT 1
5 UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=386&id=592&lang=en&task=blogcategory' AND `oldurl` = 'Footer/Press/'
6 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 386 ) ORDER BY menuid DESC LIMIT 1
7 DELETE FROM jos_session WHERE ( ( time < '1268171311' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1268171311' ) AND guest = 1 AND userid = 0 )
8 SELECT * FROM jos_session WHERE session_id = '327d45ea5a5dc5f6ba192c7310c99a0f'
9 SELECT session_id FROM jos_session WHERE session_id = '773dc39bf12f935689eaad98f7c6943a'
10 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '773dc39bf12f935689eaad98f7c6943a','1268172211','','0','1' )
11 SELECT params FROM jos_mambots WHERE element = 'JC Vote' AND folder = 'content'
12 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 0
13 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 0
14 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 1
15 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 1
16 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 2
17 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 2
18 SELECT * FROM jos_menu WHERE id = 386
19 SELECT COUNT(a.id) FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_sections AS s ON a.sectionid = s.id LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 17:03' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 17:03' ) AND ( a.catid=592 ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0
20 SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CHAR_LENGTH( a.fulltext ) AS readmore, s.published AS sec_pub, cc.published AS sec_pub, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_sections AS s ON a.sectionid = s.id LEFT JOIN jos_groups AS g ON a.access = g.id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 17:03' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 17:03' ) AND ( a.catid=592 ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0 ORDER BY a.created DESC LIMIT 9
21 SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM jos_content AS a LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE a.id = 1129
22 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 386 ) ORDER BY ordering
23 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
24 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
25 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
26 SELECT * FROM jos_mambots WHERE id = '32'
27 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
28 SELECT * FROM jos_mambots WHERE id = '32'
29 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
30 SELECT * FROM jos_mambots WHERE id = '32'
31 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
32 SELECT * FROM jos_mambots WHERE id = '32'
33 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 1129 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
34 SELECT count(*) FROM jos_akocomment WHERE contentid='1129' AND published='1'
35 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
36 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
37 SELECT * FROM jos_mambots WHERE id = '32'
38 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
39 SELECT * FROM jos_mambots WHERE id = '32'
40 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
41 SELECT * FROM jos_mambots WHERE id = '32'
42 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
43 SELECT * FROM jos_mambots WHERE id = '32'
44 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
45 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
46 SELECT s.title, cat.title FROM jos_categories AS cat,jos_sections AS s WHERE cat.id = 592 AND cat.section = s.id
47 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
48 SELECT * FROM jos_mambots WHERE id = '32'
49 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
50 SELECT * FROM jos_mambots WHERE id = '32'
51 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
52 SELECT * FROM jos_mambots WHERE id = '32'
53 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
54 SELECT * FROM jos_mambots WHERE id = '32'
55 SELECT m.* FROM jos_menu AS m WHERE menutype = 'footerMenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
56 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
57 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=1028'
58 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=13'
59 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=624'
60 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=743'
61 SELECT m.* FROM jos_menu AS m WHERE menutype = 'FooterRow2' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
62 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=29&lang=en'
63 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=762'
64 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=1416'
65 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=1445'
66 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
67 SELECT * FROM jos_mambots WHERE id = '32'
68 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
69 SELECT * FROM jos_mambots WHERE id = '32'
70 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
71 SELECT * FROM jos_mambots WHERE id = '32'
72 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
73 SELECT * FROM jos_mambots WHERE id = '32'