SELECT *
FROM jos_session
WHERE session_id = '9661178919dd17011b2677e69227a0da'
DELETE
FROM jos_session
WHERE ( time < '1260114822' )
SELECT *
FROM jos_session
WHERE session_id = '9661178919dd17011b2677e69227a0da'
UPDATE jos_session
SET `time`='1260115722',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='qUpaWR5JASHwb998p3zVn35q7B7hF6qJLpVIQGJa-eoIDF-MfpVNivaOBKkVXjR4UGyduMpY1QDaau0cLzJNHHGidf4v93uYNoG5s_aW78V9sQCd8bViS4CgKdgZXQdhDag4daN12J5aqGwNgUaR5SSIYlH0IN2azuHk6Vlh1xvT6kuYtIfOgr943pI6DPI2pbe8QLF-JBL0aCgAV9Tst0j243OOi7_4brHixn3Gcj8dJmZNjp1E2H9ble2OLfMxzSoSJQjUlQkDN3cY8mECMPYGsyFViTtJCPsibWjKb3zjtxF_q0wQ_pGunUf7-rEtAUw9POv_gpv3f9y0RdSooWokqXEtYLPRV01F3XshfXftbiDza4ui8-m3ryCjd6V4tj2CoYhKA9NihCBoM55vawVBFUC0KO-8ow-3KUkvVPhjBBP5vVZyZCEoM_fggKKlqGlhFbcFnWBgN7IG1eKSdA7DaGRDrqnY2e1WpJRpRg9hgKVv51qMAbfIPpYwRXMy0_pNiJtq9bY0SCxKPieTEZmn5yWYKLu7uVY0D5jNciELd9wBdQCgyjfbSouZX4wWeuUsr7EWuk5pyXixGHEgzfoLcQ2SnMYVZH5Bq6EBgS7UbsrcWeXPpyhVYIRug7qlbnuihU6z7g_NOb5DCIBa9azh_VA0Ya8yM-DJ-r5ByuxcP7zxqLFB3csZNpqUHyj3xJKINO1N67B_WpGzAYgS3EpTKGouWrARTvHH83X1RDw3wuQeCmUOqIw7rFsdOnk3DAHTHsrRZ8YEbdbp8wjHcYoaJShFKhiwVXwOXJLJUclka42GuxLU8M73CWUEJBFM_MWkGssUSPVwQmL0goKrrpDxXBqKHg9C_GB9aDciMO5NfPAW_u9w_piBv-M9j6DLPyWra-BB0g7akm5votv_XrgB2YCpd6xy3EFvg3whQ1nd5JsOOSQKKkR7bV5m6wMbIM-1dXsHuGJbRG-sUVaDveuGCcLnOJ-U-LjFUIkVNoR438sM3Gf4hSAJSNnD2VwOTcjg8VocGwKuP3DmGb0t8nWSgmXcrvSitHQDeUQ_61x9sZ1tEstTbGTinCiZl7GKAcgcLgg7seC0fobMZKD5r5uwk6ckvgLVOusmbMmsK4HLijEIyBnSGBsv8embObfsNcPBiYR4EZEewv9eegTDOJHCMLjxlS1Xpmtv29IRQWdVl4DUOZmOc55IyEGKd9JoATsfPUWx0g-oHZJpEoeJt5Z7gg7evbYxgRikWpF2mEUr0a3kFCDPS6Nt7Q7yn30Y3abQUn63BVLARTMpiHRlCsIzCXta9v_IkFita_AzmzEKnpSL0JnV4cM4lIFGotBQOTJau-1gmuyCjs53nlPiUtChVoHmL-aApJK7FXlhznylbT6vNrgIc7hZFz9RkolLL0bS5YTpWbQe1-f5EkIDFPg6pjMX7GrGXflq-A4XyeU9C7qSK76yc0L9fhJuO97yvXMmDQYw0kYvQgrR9-wEuZcNBI-Hvi4FB-iRkN5ZBs53j2w_V8zemUJ1xb3CLp6XtNcYX6BRk1RMG8jeA2RtKw..'
WHERE session_id='9661178919dd17011b2677e69227a0da'
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 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 = 50)
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 = 6
AND a.access <= 0
AND ( ( a.created_by = 0 ) OR ( a.state = 1 OR a.state = -1)
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-12-06 16:08:42' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-12-06 16:08:42' ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='6'
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 = 50 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 33
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 8
