SELECT *
FROM jos_session
WHERE session_id = 'cb4ef566aa70279a3ae874ea0e2c35cc'
DELETE
FROM jos_session
WHERE ( TIME < '1329983095' )
DELETE
FROM jos_session
WHERE ( TIME < '1329983095' )
SELECT *
FROM jos_session
WHERE session_id = 'cb4ef566aa70279a3ae874ea0e2c35cc'
UPDATE `jos_session`
SET `time`='1329985495',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='4rdEbr9lzS0HPhnFDER05BxQ10JO-LUlpnAdxroalM62Vjgo5LjPPXQyGhLmI2tgoJupcRpuwLd9wGTEjSCuJwr_QtXz8Eey9TZg1cUIBk952ml1UQwRnDJTq5cjx5kKd2tvsD8eFSvFrF-08T_apNWzB03Lm587YIB6H-FdFNiN3_kRKHt7fiVVAF4zQYiSGR5WfXpGwMpKbju2_zZ7s5aIwPKwyK2NBPnqpslZ9hOvpPhQrIwKRoRR2WGRyOyZEDZx5_7odRcBiX3OMjfO8wg51ix3fD8QefM88Cmy49McDZoKRxTqwpwiPDBRPKHUMLcJnu8k0DJUtMluxmyG1n46KBQFGlCZOFR0hvmFKcXpNDgAPiRo5PsFGG32ZQKrAZCB_xO1PTnmXBmV45zA8J-ixHyn-mgWWf4Mt5v8RKSRW6TP3m3IcvBROpAr5o8Vebb-cFZMGoNuExHWAJMaUZHwFyZUNWBOiYM0ycKqsXTguYkd3nLzA3EOJLQXnfQEDBi3mVOLTTS-uJ4ISqMnDDpTUIG92quJi1VR1D_B_ArKvx7f0tPWpxWQzcdV-BS3UuQiQLBjaG6hAB3AWGxvdLa-hLpfdXN4dpB3LW8cbqOszwQOlM5AgK6tJjWCLEJPnfCGz2wQY1NUcfoa5B-jfB9gFRi1yg36Zn-ayNGkQx5VaHW022GfzdgOk5bgBsr3q-Q52SGyHBx9-b64XK16NgdKsET93ELBVDJOcYnfaUtjuMknlRgBPd0W1ySlrKFAyIGZABE7ZtJX1GgC8gp7SjTsOw6ModU2TUUQM6cBliwD6qX9l-wyZWPDeqFzD6pC47fCtaUAmbf5gDddPK7kzkRaeveCcUdlQxNROsdtNRsQw6456Z8XiY32bUlrf6BzP4LeF2qbs5tWRnzSzl6xW6O6olHRirbOy01lqp-9dMG3TnTG6ZLcDy9qSfzTMO5wks-ityZB8_F4dWSez9BABINkfpGPHS4A9HE-0Fvg5c_Ev79NldE05bGFTBVkDVrjvhLWjfEUxfakxL9nogAVv8GAYs6-B89eYRVvVXD6vvMr8OuwEetvrENEQkjUUNoPvWyx5N3UCyTQdHRkbPOWgWWUrbSLjoz-Mzn1B1xsIc1wkb5IGjRNDAU8Y1fJVPozT9wMDVH_la5AZyPnm-9fqfpkku6zKh5d7W-H1KmziSUPE6L-9GyzJYpVykVdEOfNKLtYUkQx7MsvpaMRqWA2mXS-_QmDKPri9xP6HeP_JaGOrV8t82yFlN7bbAF0bSf0lUSRzOvWarMuCz6U6uNZfBJ9aZpE9IIoIfaS3j1tNeFUI9YWcpc3EAO0QhkAw3-PLD8ful_fc7IIq-W_Ra7VWEH6IjiwJakXxMoMbY72ra4wLqHkZgVReCLc2edEtc9UGBlMKdflWmG2-eZjZM34IRXlbXZ1ruyjAYIWaBJazCT30PrySLB-b7kMhIc4rxhMUgy8zxTu3SQtxJxp-a5PLhpkcvdnpoqxMlJuMHevUn_7TPE_Fhrdh1YtBOWMTtoWG0yIvzYejUQ7GclOjrNp4EI380eT1kvogmQVb5SOSS7Lzv-ovXlVXgetiXnq4S13wbTvXbv_KPu7Ov_3lGdfBZk-lb2O-xE_5ZRHoBztEsXcSj6GNYTFuYTdJ10kr3eoHGHdcjjpDKLEL7Ub6oNKUIYdGXf7erPTem_chRAAIyQbAf_tlreb0PgAIZlTBLZaZ8Hllvz64YLKth0-BOogkLGbB23eRLRIJfI1RwYIO1qjeAgJwcc2b3oLmqrkumbihe55_6Jtv-gC_Sa62tWwwQ..'
WHERE session_id='cb4ef566aa70279a3ae874ea0e2c35cc'
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 'index.php/about-joomla.html%' OR sefurl LIKE 'index.php/about-joomla.html%'
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 = 28)
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 = 9
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 08:24:55' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 08:24:55' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='9'
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 = 28 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
