SELECT *
FROM jos_session
WHERE session_id = 'c675e6018c8a24d0ef83f101d5ab7703'
DELETE
FROM jos_session
WHERE ( TIME < '1329958180' )
SELECT *
FROM jos_session
WHERE session_id = 'c675e6018c8a24d0ef83f101d5ab7703'
UPDATE `jos_session`
SET `time`='1329959080',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:22;s:19:\"session.timer.start\";i:1329958302;s:18:\"session.timer.last\";i:1329958980;s:17:\"session.timer.now\";i:1329959005;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:98:\"/hermes/waloraweb014/b1256/moo.c1paving/3guysentertainment/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:16:\"com_mailto.links\";a:21:{s:40:\"7556a625d32345f996421e4ba1c6618ba1edde2e\";O:8:\"stdClass\":2:{s:4:\"link\";s:55:\"http://www.3guysentertainment.com/slides/water-fun.html\";s:6:\"expiry\";i:1329958303;}s:40:\"4f27335b34b5417c7b600843e7b4a49cad5df49c\";O:8:\"stdClass\":2:{s:4:\"link\";s:57:\"http://www.3guysentertainment.com/slides/combo-units.html\";s:6:\"expiry\";i:1329958331;}s:40:\"523a1704b8e30f959279f2768eda01bf5a4d3238\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.3guysentertainment.com/landing-page/crafts.html\";s:6:\"expiry\";i:1329958356;}s:40:\"5b619ba14260c4ee492773933da0a2025c696c2e\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.3guysentertainment.com/carnival-games/games.html\";s:6:\"expiry\";i:1329958381;}s:40:\"2355dd7708eab084d28209d31abc0876d009d6d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.3guysentertainment.com/slides/play-stations.html\";s:6:\"expiry\";i:1329958465;}s:40:\"49e24ac808e91484335a1ade1dd2205c7e6ae494\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"http://www.3guysentertainment.com/jump-infltables/jumps.html\";s:6:\"expiry\";i:1329958504;}s:40:\"d9574d23e8bcec4bae99ef0ae968380905d959b8\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"http://www.3guysentertainment.com/slides/obstacle-courses.html\";s:6:\"expiry\";i:1329958532;}s:40:\"2fd93d1dc941b027ffcee4016af030d3ae5446fc\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"http://www.3guysentertainment.com/slides/big-kahuna-slide.html\";s:6:\"expiry\";i:1329958562;}s:40:\"8acb06302811bf766fe18c318482552f11ea4ba1\";O:8:\"stdClass\":2:{s:4:\"link\";s:63:\"http://www.3guysentertainment.com/balloons/helium-balloons.html\";s:6:\"expiry\";i:1329958589;}s:40:\"d5e40aef58760ea37940b974d975f0a2010f979a\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"http://www.3guysentertainment.com/jump-infltables/kiddie-area.html\";s:6:\"expiry\";i:1329958634;}s:40:\"3ce021bdbdfbc03c7805f824250de355a3520cf7\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.3guysentertainment.com/jump-infltables/sea-of-balls.html\";s:6:\"expiry\";i:1329958661;}s:40:\"ee0dbc680588ca13966f27d0d8e6d68479892c84\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.3guysentertainment.com/sports-inflatables/laser-tag.html\";s:6:\"expiry\";i:1329958732;}s:40:\"2e7111fa66c901a0452fe75cdb792d3174b9fb49\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.3guysentertainment.com/jump-infltables/tiger-bounce.html\";s:6:\"expiry\";i:1329958759;}s:40:\"8e84932210f2a036ccc50dc0bc8d5784948fd761\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"http://www.3guysentertainment.com/jump-infltables/crayon-bounce.html\";s:6:\"expiry\";i:1329958786;}s:40:\"c5fa93d53af4efd6004f7cc56e71bbcc10f2f7d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"http://www.3guysentertainment.com/jump-infltables/princess-jump.html\";s:6:\"expiry\";i:1329958814;}s:40:\"c29be54ae45c17330fb6e8be964a2b91716db141\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"http://www.3guysentertainment.com/jump-infltables/kiddie-kastle.html\";s:6:\"expiry\";i:1329958847;}s:40:\"afd6a28babc4a210dc57bb54375f23b68e218162\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"http://www.3guysentertainment.com/sports-inflatables/bungee-run.html\";s:6:\"expiry\";i:1329958899;}s:40:\"e5ff54fd56870a4345943f2d6e5dcab4bde748ee\";O:8:\"stdClass\":2:{s:4:\"link\";s:69:\"http://www.3guysentertainment.com/slides/giant-slide-mtn-clibmer.html\";s:6:\"expiry\";i:1329958929;}s:40:\"dbd96f6bd21672d8b497f8b8c5037017bcc5978d\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.3guysentertainment.com/landing-page/tunnel-inflatables.html\";s:6:\"expiry\";i:1329958955;}s:40:\"59cb256c1574fdbe8a94f9190f7a3953b5f3c3ea\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.3guysentertainment.com/landing-page/group-inflateables.html\";s:6:\"expiry\";i:1329958980;}s:40:\"2997477c9057ba7de6b2e9c1a395b43a4a230c99\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.3guysentertainment.com/jump-infltables/school-bus-jump.html\";s:6:\"expiry\";i:1329959005;}}s:13:\"session.token\";s:32:\"25559dae1dc266ff1605978910a52e83\";}'
WHERE session_id='c675e6018c8a24d0ef83f101d5ab7703'
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
UPDATE jos_redirection
SET cpt=(cpt+1)
WHERE `oldurl` = 'sports-inflatables/buddy-boxing.html'
AND `newurl` != ''
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 = 21)
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 = 22
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:04:40' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:04:40' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='22'
SELECT `file`, `params`
FROM `jos_sefexts`
SELECT `oldurl`
FROM `jos_redirection`
WHERE `newurl` = 'index.php?option=com_mailto&link=14ad77873e53d2a2a00e20e2b24ac1878beae3e2&tmpl=component'
SELECT `file`, `title`, `id`
FROM `jos_sefexts`
SELECT `name` AS `name`, `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_mailto'
AND `published` > 0
SELECT `name` AS `name`, `id`
FROM `jos_menu`
WHERE `link` LIKE 'index.php?option=com_mailto%'
AND `published` > 0
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 = 21 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '62'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '33'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '3'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '32'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '78'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '52'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '26'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '27'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '75'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '65'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '28'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '143'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '29'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '76'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '77'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '53'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '18'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '47'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '55'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '54'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '63'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '126'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '122'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '132'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '128'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '121'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '127'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '133'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '123'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '125'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '124'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '120'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '70'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '49'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '149'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '66'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '16'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '74'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '69'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '72'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '160'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '139'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '67'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '83'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '73'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '57'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '60'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '153'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '110'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '52'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '17'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '109'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '34'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '154'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '159'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '4'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '157'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '129'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '130'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '117'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '111'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '119'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '116'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '50'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '118'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '115'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '114'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '143'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '140'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '141'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '93'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '100'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '105'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '92'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '97'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '91'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '104'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '162'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '96'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '99'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '101'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '102'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '98'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '103'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '106'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '107'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '108'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '95'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '94'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '87'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '8'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '88'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '64'
SELECT `oldurl`
FROM `jos_redirection`
WHERE `newurl` = 'index.php?option=com_content&catid=9&id=64&view=article'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '9'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '10'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '11'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '112'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '44'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '36'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '37'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '45'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '84'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '85'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '43'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '86'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '41'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '131'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '22'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '24'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '25'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '23'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '21'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '161'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '81'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '13'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '48'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '82'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '12'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '14'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '137'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '79'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '39'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '80'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '89'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '90'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '58'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '59'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '20'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '113'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '38'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '42'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '46'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '40'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '151'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '150'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '152'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '156'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '155'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '163'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '164'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '165'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '19'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '6'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '146'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '142'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '145'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '147'
