SELECT *
FROM jos_session
WHERE session_id = '0a1af153882afc9cd76a54d0928fab23'
DELETE
FROM jos_session
WHERE ( TIME < '1369084810' )
SELECT *
FROM jos_session
WHERE session_id = '0a1af153882afc9cd76a54d0928fab23'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0a1af153882afc9cd76a54d0928fab23','1369086610','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'option=com\_content&view=article&id=589:super-heroes-shirk-duties&catid=51:pop-culture&Itemid=103%' OR sefurl LIKE 'option=com\_content&view=article&id=589:super-heroes-shirk-duties&catid=51:pop-culture&Itemid=103%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_content&view=article&id=589:super-heroes-shirk-duties&catid=51:pop-culture&Itemid=103%' OR sefurl LIKE 'index.php?option=com\_content&view=article&id=589:super-heroes-shirk-duties&catid=51:pop-culture&Itemid=103%'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 103)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
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 = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 589
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-20 21:50:10' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-20 21:50:10' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='589'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 103 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *
FROM jos_swmenu_config
WHERE id = 128
SELECT jos_menu.* , jos_swmenu_extended.*
FROM jos_menu
LEFT JOIN jos_swmenu_extended
ON jos_menu.id = jos_swmenu_extended.menu_id
AND (jos_swmenu_extended.moduleID = '128' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'starting-lineup'
AND published = '1'
ORDER BY parent, ordering
SELECT *
FROM jos_swmenu_config
WHERE id = 68
SELECT jos_menu.* , jos_swmenu_extended.*
FROM jos_menu
LEFT JOIN jos_swmenu_extended
ON jos_menu.id = jos_swmenu_extended.menu_id
AND (jos_swmenu_extended.moduleID = '68' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'Clubhouse'
AND published = '1'
ORDER BY parent, ordering
SELECT *
FROM jos_swmenu_config
WHERE id = 79
SELECT jos_menu.* , jos_swmenu_extended.*
FROM jos_menu
LEFT JOIN jos_swmenu_extended
ON jos_menu.id = jos_swmenu_extended.menu_id
AND (jos_swmenu_extended.moduleID = '79' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'socialmedia'
AND published = '1'
ORDER BY parent, ordering
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 226
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 25
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 25, '2013-05-20' )
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 6
AND catid = 242
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 32
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 32, '2013-05-20' )
Superman, Batman, Catwoman, The Incredible Hulk, The Mighty Morphin Power Rangers, and many more were on hand in LA this weekend to break the world record for most superheroes in one place at one time, leaving the rest of the world in total chaos.