SELECT *
FROM jos_session
WHERE session_id = 'cb4ef566aa70279a3ae874ea0e2c35cc'
DELETE
FROM jos_session
WHERE ( TIME < '1329983137' )
SELECT *
FROM jos_session
WHERE session_id = 'cb4ef566aa70279a3ae874ea0e2c35cc'
UPDATE `jos_session`
SET `time`='1329985537',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='BTcVuyGzromIeCb5OHsIlC9GctBB5yQ6cUeFjq98PqDWngFEvFWcZYoSoTCkEGedcya8Py5bgO35XNQaIOQMzZvtI3r1Pa2ILaIThbqj_2IinuJ_0p-zuThR76uIA1Ml5qxK1WVSIwiT4vbVdZhyckcBLMGVU68TJPlq92kHqEOzD2XsVcLeTBS3C8Mgiht5tho84-mA6Q1CN-1huNjM0sLDUih7Uir3WSVOjAkoRKiJe0f7QY5agSDioroOOiDlIcTOw-y3C2jQqdIoB8q0Wwg-uDiNRKZs0od8HR3KNMQ9C9eNUuXbhIBPcPNeHKiCfYxsANCScj8XrcNTQiRSWgZPz2s0CvHOU-Q4A11lLh8W1U40xup9n1Xlph4O0SuLAGndS_qFWPKWU3Q1OvpS5mF0m3StupAJNMVvuli2IReeTGyiye89wQclV9ZlDGYcjXkNqpIN0ix8_ZxDV8ZdhLx73UCrPZ2TRBilfEVNPLVzUVRYRrIP8RavvKwVueIGNVZ3BKnftLF2Wrdc3RO5utEtye0JWz6-76RNutps5vZz51OXBpJPK_VXlHaf5cBhcOzgnboUvhM0RzZSAYK9Fe1O5ZWTa555qaxJX-fG7RNlGe06-xm3k3gBgf86wkds-tFMBZycCq1COxlQMoEZkFuGB_U9pzryQUrCEfdwC-Q8a5RwplejWuYnCzmU8F8vBp1YAZ0Yrh-G_F5_HJHfKTPnCpA6LyxxDraD4B1G-HJF7mN4udTtiMPtLLT6x3oXZbqXq4iEjO-cmRY1hh9RzC1ezHo-Xbk0gkSQXiNniZfn-BEFnMVcXYoq1ETlo3jTSRpNu18J6pQX1XGJmursjZAePCT6q062gA-ZKLZ0OLTbpE08oObjbJ9o24fuOB3KmV1Cdc55VjdkJlbxh8X71jggyFYn0qHpHE8ptG5iXziIfOvWOVU4QU90lutaCMvrwlboArlrNX3iDCpNFbuRIwZ2jflAK69-xPpRAQf-yMLzAXFZCyotDxq2sFyh-3442uYZWZUlyg0m5LGUYxihfUEAR5FJnaNKtLCMEvkiqjwuytozja4NChLFV77TbyfP7QQTF9WbH-yPcw94fzIR8h7jEVr44Jcv85Z9uwPs05XiMPrvRAXmgr6y12yPjvyX98cZ4uLbx0spqoPvU2-4YOB2WczyHOP7tRpk3nqv_lbaUuNWaqupISdd8qsQSgF4pE9jG7GWT9jpnS8h-mXIl7m02sw-M6nsWkhNJekJyRfXEL_UUB1muA8eGE9Ynh0NTfmUQChEISbHIUxjecYVCEOADtwu0IxlU29-I9uL5VcxB4xFOLbImfYqhHI77Xh8Of7YQ0EfcIpeBLBPSU0YbKWOQKCs6ZFhNKFGwbOu7uIHeS0jFzI86SAYxMJFfE2j-sjmkaLAHFgAEjrfyTzh7IbSWdM9EeYps0FIBskfL3oJcuLmD-tJAqTuRGeGCj_PQahu4TKsGoo6n11fV9NSa7GMNUmjJSbCpIFV9Qs9pulam_IFKhkVrgxfS_4vI0zGj0iOM_rjrl99_GywIE5GqZuLSZTdpmMzjRmkSNra8zHW4W_BFexMedMRcsSLaa0XIw2lody7NKElzB2artKu5t7-AWPzGINiT-n3ieyFre-LFwEep0XnO8vMrnb470-Czu0K5vG7KIagDchtbqb2rX5fvEfO-0ggdfCQJhyNKZBJ85z3v_JK_XYg-k1b4xLJmlww9hdn01Z1_f7Lym0_uLE37CwfIIPYT4dnHk-xZ2vlrfYvJKRZCQfhjQa1ooueVL_BX2Cuda6M0q7yDd2AvA..'
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/more-about-dance.html%' OR sefurl LIKE 'index.php/more-about-dance.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 = 37)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_sections
WHERE id = 4
LIMIT 0, 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
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.access <= 0
AND s.id = 4
AND s.access <= 0
AND cc.access <= 0
AND s.published = 1
AND cc.published = 1
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 08:25:37' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 08:25:37' )
ORDER BY a.created DESC
LIMIT 0, 9
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
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.access <= 0
AND s.id = 4
AND s.access <= 0
AND cc.access <= 0
AND s.published = 1
AND cc.published = 1
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 08:25:37' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 08:25:37' )
ORDER BY a.created DESC
SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
FROM jos_categories AS a
LEFT JOIN jos_content AS b
ON b.catid = a.id
AND b.state = 1
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2012-02-23 08:25' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-23 08:25' )
AND b.access <= 0
WHERE a.SECTION = 4
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
HAVING numitems > 0
ORDER BY a.ordering
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 = 37 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
