SELECT *
FROM jos_session
WHERE session_id = 'c675e6018c8a24d0ef83f101d5ab7703'
DELETE
FROM jos_session
WHERE ( TIME < '1329957402' )
SELECT *
FROM jos_session
WHERE session_id = 'c675e6018c8a24d0ef83f101d5ab7703'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'c675e6018c8a24d0ef83f101d5ab7703','1329958302','','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
UPDATE jos_redirection
SET cpt=(cpt+1)
WHERE `oldurl` = 'slides/water-fun.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 = 115)
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 = 73
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 00:51:43' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 00:51:43' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='73'
SELECT `file`, `params`
FROM `jos_sefexts`
SELECT `oldurl`
FROM `jos_redirection`
WHERE `newurl` = 'index.php?option=com_mailto&link=7556a625d32345f996421e4ba1c6618ba1edde2e&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 = 115 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'