SELECT * FROM jos_session WHERE session_id = '975dad9ec097c4452e73d54257b91c6a'
DELETE FROM jos_session WHERE( time < '1283703785')
SELECT * FROM jos_session WHERE session_id = '975dad9ec097c4452e73d54257b91c6a'
UPDATE`jos_session` SET`time`='1283704685',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1283704594;s:18:\"session.timer.last\";i:1283704594;s:17:\"session.timer.now\";i:1283704641;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:64:\"/home/baylin/public_html/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:19:\"com_mailto.formtime\";i:1283704594;s:13:\"session.token\";s:32:\"7ce96f964d1309e86abd92a268e65049\";}' WHERE session_id='975dad9ec097c4452e73d54257b91c6a'
SELECT * FROM jos_components WHERE parent = 0
SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDERBY ordering
SELECT m.*, c.`option`AS component FROM jos_menu AS m LEFTJOIN jos_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDERBY m.sublevel, m.parent, m.ordering
SELECT template FROM jos_templates_menu WHERE client_id = 0 AND(menuid = 0OR menuid = 0) ORDERBY menuid DESC LIMIT0, 1
SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFTJOIN 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 = 0OR mm.menuid = 0) ORDERBY position, ordering
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug FROM jos_polls WHERE id = 0 AND published = 1
5 legacy queries logged
SELECT id, name FROM jos_fastball_season WHERE isdefault = 1
SELECT id, name FROM jos_fastball_team WHERE defaultteam = 1
SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
DATE_FORMAT(a.gamedatetime, '%a, %M %D')AS gamedate,
DATE_FORMAT(a.gamedatetime, '%l:%i %p')AS gametime,
h.name AS hometeam,
h.logo AS homelogo,
v.name AS visitingteam,
v.logo AS visitinglogo,
t.description AS gametype,
l.name AS fieldname,
l.address AS address,
l.city AS city,
l.state AS state,
l.zipcode AS zipcode,
s.description ASSTATUS,
u.name AS editor
FROM jos_fastball_schedule AS a
LEFTJOIN jos_fastball_team AS h ON a.hometeam = h.id
LEFTJOIN jos_fastball_team AS v ON a.visitingteam = v.id
LEFTJOIN jos_fastball_gametype AS t ON a.gametype = t.id
LEFTJOIN jos_fastball_location AS l ON a.location = l.id
LEFTJOIN jos_fastball_gamestatus AS s ON a.STATUS = s.id
LEFTJOIN jos_users AS u ON u.id = a.checked_out
WHERE(a.season = 3)
GROUPBY a.id
ORDERBY a.gamedatetime
SELECT id FROM jos_fastball_team WHERE(defaultteam = 1)
SELECT visitingteam, hometeam, runshome, runsaway FROM jos_fastball_schedule WHERE(STATUS = 3 AND FIND_IN_SET(gametype, '1') AND season = 3 AND(visitingteam = 1 || hometeam = 1))