SELECT *
FROM jos_session
WHERE session_id = 'o90lkkuq2u3fdar175a9jqo066'
DELETE
FROM jos_session
WHERE ( time < '1327697921' )
SELECT *
FROM jos_session
WHERE session_id = 'o90lkkuq2u3fdar175a9jqo066'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'o90lkkuq2u3fdar175a9jqo066','1327698821','','0','1','0' )
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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 68)
ORDER BY menuid DESC
LIMIT 0, 1
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 =24
ORDER BY g1.name
SELECT count(*)
FROM jos_menu
WHERE id = 68
AND link LIKE "%com_hwdvideoshare%"
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 AS video
LEFT JOIN jos_users AS u
ON u.id = video.user_id
WHERE video.approved = "yes"
AND video.published = 1
AND video.public_private = "public"
SELECT video.*, u.name, u.username
FROM jos_hwdvidsvideos AS video
LEFT JOIN jos_users AS u
ON u.id = video.user_id
WHERE video.approved = "yes"
AND video.published = 1
AND video.public_private = "public"
ORDER BY video.date_uploaded DESC
LIMIT 0, 20
SELECT video.*, u.name, u.username
FROM jos_hwdvidsvideos AS video
LEFT JOIN jos_users AS u
ON u.id = video.user_id
WHERE video.approved = "yes"
AND video.published = 1
AND video.public_private = "public"
AND video.featured = 1
ORDER BY rand()
LIMIT 0, 4
SELECT id, category_name
FROM jos_hwdvidscategories
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 35
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 27
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 27
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 26
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 22
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 31
SELECT access_v, access_v_r
FROM jos_hwdvidscategories
WHERE id = 21
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 = 68 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
CREATE TABLE IF NOT EXISTS jos_vvisitcounter (id int(11) UNSIGNED NOT NULL AUTO_INCREMENT, tm int NOT NULL, ip varchar(16) NOT NULL DEFAULT '0.0.0.0', PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=1
SELECT MAX(id)
FROM jos_vvisitcounter
DELETE
FROM jos_vvisitcounter
WHERE id<'70030'
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE ip='38.107.179.221'
AND (tm+'900')>'1327698822'
INSERT INTO jos_vvisitcounter (id, tm, ip)
VALUES ('', '1327698822', '38.107.179.221')
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm>'1327647600'
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm>'1327561200'
AND tm<'1327647600'
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm>='1327302000'
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm>='1325401200'
SELECT count(*)
FROM jos_menu
WHERE id = 68
AND link LIKE "%com_hwdvideoshare%"
SELECT a.tags, a.date_uploaded
FROM jos_hwdvidsvideos AS a
WHERE a.published = 1
AND a.approved = "yes"
ORDER BY a.date_uploaded DESC
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.name) THEN CONCAT_WS(":", cc.id, cc.name) 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 <= "2012-01-27 21:13:42" )
AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2012-01-27 21:13:42" )
AND cc.id = 68
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
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.name) THEN CONCAT_WS(":", cc.id, cc.name) 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 <= "2012-01-27 21:13:42" )
AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2012-01-27 21:13:42" )
AND cc.id = 85
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT *
FROM jos_content
WHERE id = '1134'
SELECT *
FROM jos_content
WHERE id = '1133'
SELECT *
FROM jos_content
WHERE id = '1132'
SELECT *
FROM jos_content
WHERE id = '1129'
SELECT *
FROM jos_content
WHERE id = '1134'
SELECT *
FROM jos_content
WHERE id = '1133'
SELECT *
FROM jos_content
WHERE id = '1132'
SELECT *
FROM jos_content
WHERE id = '1129'
SELECT *
FROM jos_content
WHERE id = '1134'
SELECT *
FROM jos_content
WHERE id = '1133'
SELECT *
FROM jos_content
WHERE id = '1132'
SELECT *
FROM jos_content
WHERE id = '1129'