113 queries executed

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 13
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
 LIMIT 14
DELETE FROM jos_session
 WHERE ( time < '1150235809' )
 AND guest = 0 
 AND gid > 05
DELETE FROM jos_session
 WHERE ( time < '1150235809' )
 AND guest = 1 
 AND userid = 06
SELECT *
 FROM jos_session
 WHERE session_id = '0c0c911ddb8c01b724e7d10fd9b602ec'7
UPDATE jos_session SET `time`='1150236709',`userid`='62',`usertype`='',`username`='Pinhead',`gid`='1',`guest`='0' WHERE session_id='0c0c911ddb8c01b724e7d10fd9b602ec'8
SELECT params
 FROM jos_users
 WHERE id = 629
SELECT access
 FROM jos_menu
 WHERE id = 110
SELECT *
 FROM jos_menu
 WHERE id = '1'11
SELECT a.id, a.title, a.title_alias, a.introtext, 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, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore,
 ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND a.access <= 1 AND cc.access <= 1 AND s.access <= 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2006-06-14 00:11:49'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2006-06-14 00:11:49' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering12
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 113
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 114
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 015
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 1
 AND folder = 'content'
 ORDER BY ordering16
SELECT a.id FROM jos_components AS a WHERE a.name = 'joomblog'17
SELECT *
 FROM jos_components
 WHERE id = '139'18
INSERT IGNORE INTO jos_joomblog_sections  (sectionid, commented, locked) SELECT id, 1, 0 FROM jos_sections19
INSERT IGNORE INTO jos_joomblog_categories  (categoryid, commented, locked) SELECT id, 1, 0 FROM jos_categories20
SELECT  ifnull(jbs.commented,1) AS section_commented, ifnull(jbs.locked,0) AS section_locked,  ifnull(jbc.commented,1) AS category_commented, ifnull(jbc.locked,0) AS category_locked,  ifnull(jbco.commented,1) AS content_commented, ifnull(jbco.locked,0) AS content_locked  FROM jos_content AS c  LEFT JOIN jos_joomblog_sections   AS jbs ON c.sectionid =jbs.sectionid  LEFT JOIN jos_joomblog_categories AS jbc ON c.catid=jbc.categoryid  LEFT JOIN jos_joomblog_content    AS jbco ON c.id=jbco.contentid  WHERE c.id='192'21
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=192) AND (published=1)22
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=192) AND (published=0)23
SELECT id FROM jos_mambots WHERE element = 'bot_adsense' AND folder = 'content'24
SELECT *
 FROM jos_mambots
 WHERE id = '22'25
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 19226
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 19227
SELECT a.id FROM jos_components AS a WHERE a.name = 'joomblog'28
SELECT *
 FROM jos_components
 WHERE id = '139'29
INSERT IGNORE INTO jos_joomblog_sections  (sectionid, commented, locked) SELECT id, 1, 0 FROM jos_sections30
INSERT IGNORE INTO jos_joomblog_categories  (categoryid, commented, locked) SELECT id, 1, 0 FROM jos_categories31
SELECT  ifnull(jbs.commented,1) AS section_commented, ifnull(jbs.locked,0) AS section_locked,  ifnull(jbc.commented,1) AS category_commented, ifnull(jbc.locked,0) AS category_locked,  ifnull(jbco.commented,1) AS content_commented, ifnull(jbco.locked,0) AS content_locked  FROM jos_content AS c  LEFT JOIN jos_joomblog_sections   AS jbs ON c.sectionid =jbs.sectionid  LEFT JOIN jos_joomblog_categories AS jbc ON c.catid=jbc.categoryid  LEFT JOIN jos_joomblog_content    AS jbco ON c.id=jbco.contentid  WHERE c.id='165'32
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=165) AND (published=1)33
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=165) AND (published=0)34
SELECT id FROM jos_mambots WHERE element = 'bot_adsense' AND folder = 'content'35
SELECT *
 FROM jos_mambots
 WHERE id = '22'36
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 16537
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 16538
SELECT a.id FROM jos_components AS a WHERE a.name = 'joomblog'39
SELECT *
 FROM jos_components
 WHERE id = '139'40
INSERT IGNORE INTO jos_joomblog_sections  (sectionid, commented, locked) SELECT id, 1, 0 FROM jos_sections41
INSERT IGNORE INTO jos_joomblog_categories  (categoryid, commented, locked) SELECT id, 1, 0 FROM jos_categories42
SELECT  ifnull(jbs.commented,1) AS section_commented, ifnull(jbs.locked,0) AS section_locked,  ifnull(jbc.commented,1) AS category_commented, ifnull(jbc.locked,0) AS category_locked,  ifnull(jbco.commented,1) AS content_commented, ifnull(jbco.locked,0) AS content_locked  FROM jos_content AS c  LEFT JOIN jos_joomblog_sections   AS jbs ON c.sectionid =jbs.sectionid  LEFT JOIN jos_joomblog_categories AS jbc ON c.catid=jbc.categoryid  LEFT JOIN jos_joomblog_content    AS jbco ON c.id=jbco.contentid  WHERE c.id='168'43
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=168) AND (published=1)44
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=168) AND (published=0)45
SELECT id FROM jos_mambots WHERE element = 'bot_adsense' AND folder = 'content'46
SELECT *
 FROM jos_mambots
 WHERE id = '22'47
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 16848
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 16849
SELECT a.id FROM jos_components AS a WHERE a.name = 'joomblog'50
SELECT *
 FROM jos_components
 WHERE id = '139'51
INSERT IGNORE INTO jos_joomblog_sections  (sectionid, commented, locked) SELECT id, 1, 0 FROM jos_sections52
INSERT IGNORE INTO jos_joomblog_categories  (categoryid, commented, locked) SELECT id, 1, 0 FROM jos_categories53
SELECT  ifnull(jbs.commented,1) AS section_commented, ifnull(jbs.locked,0) AS section_locked,  ifnull(jbc.commented,1) AS category_commented, ifnull(jbc.locked,0) AS category_locked,  ifnull(jbco.commented,1) AS content_commented, ifnull(jbco.locked,0) AS content_locked  FROM jos_content AS c  LEFT JOIN jos_joomblog_sections   AS jbs ON c.sectionid =jbs.sectionid  LEFT JOIN jos_joomblog_categories AS jbc ON c.catid=jbc.categoryid  LEFT JOIN jos_joomblog_content    AS jbco ON c.id=jbco.contentid  WHERE c.id='169'54
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=169) AND (published=1)55
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=169) AND (published=0)56
SELECT id FROM jos_mambots WHERE element = 'bot_adsense' AND folder = 'content'57
SELECT *
 FROM jos_mambots
 WHERE id = '22'58
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 16959
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 16960
SELECT a.id FROM jos_components AS a WHERE a.name = 'joomblog'61
SELECT *
 FROM jos_components
 WHERE id = '139'62
INSERT IGNORE INTO jos_joomblog_sections  (sectionid, commented, locked) SELECT id, 1, 0 FROM jos_sections63
INSERT IGNORE INTO jos_joomblog_categories  (categoryid, commented, locked) SELECT id, 1, 0 FROM jos_categories64
SELECT  ifnull(jbs.commented,1) AS section_commented, ifnull(jbs.locked,0) AS section_locked,  ifnull(jbc.commented,1) AS category_commented, ifnull(jbc.locked,0) AS category_locked,  ifnull(jbco.commented,1) AS content_commented, ifnull(jbco.locked,0) AS content_locked  FROM jos_content AS c  LEFT JOIN jos_joomblog_sections   AS jbs ON c.sectionid =jbs.sectionid  LEFT JOIN jos_joomblog_categories AS jbc ON c.catid=jbc.categoryid  LEFT JOIN jos_joomblog_content    AS jbco ON c.id=jbco.contentid  WHERE c.id='170'65
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=170) AND (published=1)66
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=170) AND (published=0)67
SELECT id FROM jos_mambots WHERE element = 'bot_adsense' AND folder = 'content'68
SELECT *
 FROM jos_mambots
 WHERE id = '22'69
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 17070
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 17071
SELECT a.id FROM jos_components AS a WHERE a.name = 'joomblog'72
SELECT *
 FROM jos_components
 WHERE id = '139'73
INSERT IGNORE INTO jos_joomblog_sections  (sectionid, commented, locked) SELECT id, 1, 0 FROM jos_sections74
INSERT IGNORE INTO jos_joomblog_categories  (categoryid, commented, locked) SELECT id, 1, 0 FROM jos_categories75
SELECT  ifnull(jbs.commented,1) AS section_commented, ifnull(jbs.locked,0) AS section_locked,  ifnull(jbc.commented,1) AS category_commented, ifnull(jbc.locked,0) AS category_locked,  ifnull(jbco.commented,1) AS content_commented, ifnull(jbco.locked,0) AS content_locked  FROM jos_content AS c  LEFT JOIN jos_joomblog_sections   AS jbs ON c.sectionid =jbs.sectionid  LEFT JOIN jos_joomblog_categories AS jbc ON c.catid=jbc.categoryid  LEFT JOIN jos_joomblog_content    AS jbco ON c.id=jbco.contentid  WHERE c.id='171'76
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=171) AND (published=1)77
SELECT COUNT(*) as numitems FROM jos_joomblog_message AS jmsg  WHERE (jmsg.contentid=171) AND (published=0)78
SELECT id FROM jos_mambots WHERE element = 'bot_adsense' AND folder = 'content'79
SELECT *
 FROM jos_mambots
 WHERE id = '22'80
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 17181
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 17182
SELECT a.*
 FROM jos_components AS a
 WHERE a.name = 'Syndicate'83
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 <= '1'
 AND m.client_id != 1
 AND ( mm.menuid = '1' OR mm.menuid = 0 )
 ORDER BY ordering84
SELECT id, name, link, parent, type, menutype
 FROM jos_menu
 WHERE published = 1
 ORDER BY menutype, parent, ordering85
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 1
 AND parent = 0
 ORDER BY ordering86
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=187
SELECT avatar, avatarapproved FROM jos_comprofiler WHERE id = 6288
SELECT count(id) FROM jos_mypms WHERE username='Pinhead' AND readstate=089
SELECT id FROM jos_menu WHERE published>=0 AND link LIKE '%com_mypms%'90
SELECT count(*) FROM jos_comprofiler_members WHERE pending=1 AND memberid=6291
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 1
 ORDER BY parent, ordering92
SELECT *
 FROM jos_users
 WHERE id = '62'93
SELECT params
 FROM jos_users
 WHERE id = 6294
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'95
SELECT DISTINCT a.username, a.userid, u.name
 FROM jos_session AS a, jos_users AS u
 WHERE (a.userid=u.id) AND (a.guest = 0) AND (NOT ( a.usertype is NULL OR a.usertype = '' ))
 ORDER BY a.username ASC96
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_datsogallery'97
SELECT *, c.access FROM jos_datsogallery as p
 left join jos_datsogallery_catg as c on c.cid=p.catid
 WHERE p.published = '1' and p.approved=1 and c.access <= 1
 ORDER BY RAND() LIMIT 198
SELECT *
 FROM jos_banner
 WHERE showBanner=199
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 2100
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-06-14 00:11:49' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-06-14 00:11:49' )
 AND a.access <= 1
 ORDER BY a.created DESC
 LIMIT 5101
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 194102
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 194103
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 193104
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 193105
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 191106
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 191107
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 190108
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-06-14 00:11:49' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-06-14 00:11:49' )
 AND a.access <= 1
 ORDER BY a.hits DESC
 LIMIT 5109
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 166110
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 166111
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_categories AS cc ON i.catid = cc.id
 LEFT JOIN jos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 166112
SELECT p.id, p.title
 FROM jos_polls AS p
 INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1113
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 1
 AND text != ''
 ORDER BY id