SELECT *
FROM jos_session
WHERE session_id = '86a1af8d10337bd9861abc95e48ec5ab'
DELETE
FROM jos_session
WHERE ( time < '1283985839' )
SELECT *
FROM jos_session
WHERE session_id = '86a1af8d10337bd9861abc95e48ec5ab'
UPDATE `jos_session`
SET `time`='1283993039',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='wItKCUHHmDuLSDwdLSXyXGKM2GUnqukgRV9GoReRbMoDwVdLCzQ0GbluwsswmMfu5OEx9Nt82Kx5f0zfAlKfg7e-h4miHJzBc2yCio-j8gn4HHwvaxDxG3UEsXf8e1CPjFS96eWH9Z4mosFP7mXcSoJehfST6u2e4GKo3Td7wmGkEhE2xzXIjm2rswsgvpJnJnJl69g32ViRmQ4J7Nds3GVxwLGbwyCf-6-rQsrcGSr9INR_Dc6UeCunWkztZPpFoOSHWL_O-csGRpVp0B-qJEXZX4ud2piSVka4ait8QUtn3Ctzc-Rwi8hTVYpop3rf4euo9LnCLk4_pEpnvpm8TYKKCxwtvjB9VUYnxBV14TVIBk-mAkSZSytjbrUMCUDNlpliejYyk0RzefX25IqEDpBcTJlpbUK0ThxMEPZu3BGLS1ilpKoOt26JA7Otp2tvPkvMZUmAGyaqkxcQVQ9Yi1kFUfVO95zBO-sepRhuo3hhka8PIyU0HDmCj77zhSiEd-TSh6Y8SySGeIzd8XaEfuI09O-cuhj7J25dTOFZwYNtZOeHN_tOwGSVPKZgBGIzDh7jw21CIb1QG0RipXq1E8jreLMkwbtpKMjQ9iNVMXNdPNghA1zaNzAzMHSDmj5grjx5PXMTFrR-8ui983f_f-YCYKNl87yv60OssOT5k9zXKkFZSiBevK2RQD3FGHMs3ROpUdcyDEFndDDXtPzZxHODe-5wWqTi_s1909tuwWmTKCVevYVvFtCiDph6eGJLl8exOxUnjg0pTghZY9VGO4FifLo6Z8yymUJB-KZxI_92ZxKKwHQ98pJ47e0OQYgxrQV3fWt62e6JwOpYdm-s5Z4BVC2i44t79xCMySP4SPDflohSH-H5clUee5JA6zfbpIZcAsNdERH83UOrpPBCogr7ElSb4mK9uLo36JIjC_j_TuYf6c_oQgODM6TJCkBhnLws3vilMOCVWkONpAO3xw7LcjNlkyObenB_lwHLJoW_xV5pAN3P64_A9FtRtyl0nyuTgGDMc8WmswM2vjxn1URJW7AAo_8KqMB6mDipBr6J5ITFrdUFUZcNGwhNsshYPGvCQPGDnkom-v2c4xzk-Vc8Q9phOvwNHHpVfGcXuukPFcBWm8VWCJdcMjKyeXRnn4C0CO0fmmmaE0FnMEiJl4qlUPDxOTvaPipCwL3C20tA2kqScF1H5qWcZwcp-_Akjab8VEcOxJOiAK-NqkScBp789QAVZMEeSb56zGVuOQI4c2RYXNcUpcDFbPmP292SsMY-cKdagARrAbOm0xzbXlaZDlFZFiNi2P8eKfI-kqWV3rzvWuCFI0qxgNwjL8BhqiK3MATPIZ7GfFnn78RAAh2yWYyLHNxK-tXiNh08LtaF3JM0NprSi5m729xM7Hw5gl79j_F0rrdPfJ-VH0xNUOd-rnxRwEGfqOZWPs8GqbGfuauJC00gZ8jxAp7Yvl5k'
WHERE session_id='86a1af8d10337bd9861abc95e48ec5ab'
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 'option=com\_hwdvideoshare&Itemid=74&task=upload%' OR sefurl LIKE 'option=com\_hwdvideoshare&Itemid=74&task=upload%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_hwdvideoshare&Itemid=74&task=upload%' OR sefurl LIKE 'index.php?option=com\_hwdvideoshare&Itemid=74&task=upload%'
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 = 74)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_jcomments_settings
SELECT count(*)
FROM jos_menu
WHERE id = 74
SELECT id ,parent,category_name, access_u, access_lev_u, access_u_r
FROM jos_hwdvidscategories
WHERE published = 1
ORDER BY category_name
SELECT g1.id AS group_id, g1.name
FROM jos_core_acl_aro_groups g1
LEFT JOIN jos_core_acl_aro_groups g2
ON g2.lft <= g1.lft
WHERE g2.id =-1
ORDER BY g1.name
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 = 74 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
SELECT a.*, 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
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-09 00:43:59' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 00:43:59' )
AND cc.id = 3
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access = 0
SELECT DISTINCT a.username, a.userid, u.name
FROM jos_session AS a, jos_users AS u
WHERE (a.userid = u.id)
AND (a.guest = 0)
AND (a.client_id = 0)
ORDER BY a.username ASC