SELECT *
FROM jos_session
WHERE session_id = 'e5340502c3c820025a5392317e5caf96'
DELETE
FROM jos_session
WHERE ( time < '1284088239' )
SELECT *
FROM jos_session
WHERE session_id = 'e5340502c3c820025a5392317e5caf96'
UPDATE `jos_session`
SET `time`='1284095439',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='y72L8BooPgSlPu6_UMPrsFUE1kvKWj2MgnK_iL_a1-5JWi8N2gR6CbWRWSI1sIPZGTDv2Arzoi1eqPobMbbrJR7hSIQD9xvImm40jtp2OR3I4aBHRV3dDFdaRbO1IqPraUwf1d1fzG6CqZF8nrtCxf0ZAnrVUkrT0jdu0HRylhGeh6laFLiu251xlczNi9W3FgSOkKQGtWoG6r-C-wvoMnk_AZuAkvV3L8zBCBl6h3sPqhfDfLzAJ8us0TEEiCVS09lKSbyuCnMmxAszsMF5F2hBwbP_PVqSBVFFkoV5u65bK-JGuTI5d71UcFoO-6RHrWSBzkVpaCN_YKqm8Y1KnWPSL3NCLxbouzP2YCEws8uVw0Je0FTVE2dekFAQPemQWI-J4CRpIvRGzj70qxgOF6NiA82-ajVHUgqxgbqB4bmzJJq1MX-UVN6EQ1MGwDKW_1VpJYlPXXs_volJZwAO52zHZ0P3cVWXBzSmecgAFTSgnBamkPcvjBicQ1S4uPsf8HVzff5o82ZUd4oQMLzYSjiBVQP9NkdbidYz_xzAL5OxNukFkOAzBuLxKlLbl_glS8jAzoQTNtSLOuuBJ5A0Ym89AYsUFdCkMtp50G2-lbsefcNwvg7vyzrza6CjTVqhyovnFc0B42E7shi0GhZfO7Ye92C1yg92lp9AJkrEoF1M_Er3qREC5GHmO5MjE90wiABqnhQ-oz2BP4qCpaowahR-K2aKna2Lheo8RzerjBbI5AdiMt3FCTJX5KCPqiMsM8PJyzR64wrt9HT3VpaZuTKGEylCRxTir_sT-BYpapRvbtn4xWnVqvvyJvKhaR5j3iTP1FGScVZdz6AWVfb5VvszC-nYmN5IrN2v4NtcMwtunHvsv0KTWPNEzfDT_3fIw3fpr4mt5nQoSyrs77cbScC7_JkixHfIdrp8MkyOkxcUt0jd4wQrwN-uUUsWgcuiBr9SNRhevVOskchpzNUtkggbTKYtmM_lhpaPq1NkahXJY0tfjHeGidHE0FkK7yB-H7KN6uWhEzT1kdcAy1kESEodpAK3u9AjK_YOCbhimcCgDK2_W1t5Mmv4OVjoHB568h0Hy-GFagAUsg2tszPSiwXqjiHjrQwz7sq1xtvNsgZoG_ugG33XAi00W_F1t81oU5wB6koT38hR9qONtHAcZbLmhwLsLThBqQMWM1MjLb3hF02fKtsuDq8uFlb6P7AxBjMKYc7ymIbsYYqfEVE0S5WWRXDz_I0IPtLOcAoySGvMoEg4UN853W75dU0Fv9cSVb7NunKa4Uf9NKDzfSzOdZYUnqXAZ7vRTX8DawjNQcYNvZTLzHDT9TMyVp_2rT4LIvWNbOfaC32JZL9nMS5LFjazMBqVouivjiE1DRZg8yqaXBOoDWkFpk5NGnYVIgbSNmK62X0CMdbQovNp_fRPj_8bD-eyMLyPR7KAp1swi-SQRvhMGqc-h9ENIx6ETweK'
WHERE session_id='e5340502c3c820025a5392317e5caf96'
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&task=viewvideo&Itemid=74&video\_id=849%' OR sefurl LIKE 'option=com\_hwdvideoshare&task=viewvideo&Itemid=74&video\_id=849%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_hwdvideoshare&task=viewvideo&Itemid=74&video\_id=849%' OR sefurl LIKE 'index.php?option=com\_hwdvideoshare&task=viewvideo&Itemid=74&video\_id=849%'
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 count(*)
FROM jos_hwdvidsvideos
WHERE published = 1
AND id = 849
AND approved = "yes"
AND public_private = "public"
INSERT INTO `jos_hwdvidslogs_views` ( `videoid`,`userid`,`date` )
VALUES ( '849','0','2010-09-09 22:10:39' )
SELECT count(*)
FROM jos_hwdvidslogs_views
WHERE videoid = 849
SELECT views
FROM jos_hwdvidslogs_archive
WHERE videoid = 849
UPDATE jos_hwdvidsvideos
SET number_of_views = 231
WHERE id = 849
UPDATE jos_hwdvidsvideos
SET number_of_views = 231
WHERE id = 849
SELECT a.*, u.name, u.username, p.avatar
FROM jos_hwdvidsvideos AS a
LEFT JOIN jos_users AS u
ON u.id = a.user_id
LEFT JOIN jos_comprofiler AS p
ON p.id = a.user_id
WHERE a.id = 849
SELECT a.*, u.name, u.username, p.avatar
FROM jos_hwdvidsvideos AS a
LEFT JOIN jos_users AS u
ON u.id = a.user_id
LEFT JOIN jos_comprofiler AS p
ON p.id = a.user_id
WHERE a.user_id = 143
AND a.published = 1
AND a.approved = "yes"
AND a.id <> 849
ORDER BY a.date_uploaded DESC
LIMIT 0, 15
SELECT a.*, u.name, u.username, p.avatar
FROM jos_hwdvidsvideos AS a
LEFT JOIN jos_users AS u
ON u.id = a.user_id
LEFT JOIN jos_comprofiler AS p
ON p.id = a.user_id
WHERE a.public_private = 'public'
AND a.id <> 849
AND MATCH (title,tags,description) AGAINST ('Saved In A Living Room LECTURE ONE The story of how God gave me success in reaching a friend through home Bible study. Also included is advice on how you can find friends to study with and some thoughts on the process of evangelism. lay training, evangelism, sowing, cultivating, reaping, truth, Adventism')
LIMIT 0, 15
INSERT INTO `jos_hwdvidsantileech` ( `expiration` )
VALUES ( 'f2c72371a6143de5fcb71ffb5c57388c' )
SELECT *
FROM jos_hwdvidsplugin
WHERE id = '5'
SELECT *
FROM jos_hwdvidsplugin
WHERE id = '4'
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date AS datetime, c.ip, c.published, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, v.value AS voted
FROM jos_jcomments AS c
LEFT JOIN jos_jcomments_votes AS v
ON c.id = v.commentid
AND v.ip = '38.107.191.92'
WHERE c.object_id = 849
AND c.object_group = 'com_hwdvideoshare_v'
AND c.published = 1
ORDER BY c.parent, c.date ASC
SELECT count(*)
FROM jos_hwdvidsfavorites AS a
WHERE a.userid = 0
AND a.videoid = 849
SELECT id, category_name
FROM jos_hwdvidscategories
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-10 05:10:39' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-10 05:10:39' )
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
Add comment