SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
DELETE
FROM jos_session
WHERE ( time < '1268279303' )
SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
UPDATE `jos_session`
SET `time`='1268280203',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1268279880;s:18:\"session.timer.last\";i:1268280157;s:17:\"session.timer.now\";i:1268280185;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:77:\"/home/diniegi1/public_html/ekitap.org/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"f1ca4c1d9f671fb300eef820f5018f2a\";}aliro_auth|a:5:{s:10:\"subj_found\";a:0:{}s:11:\"permissions\";a:0:{}s:12:\"access_found\";a:1:{s:5:\"aUser\";a:1:{i:62;i:1268280187;}}s:12:\"access_roles\";a:0:{}s:5:\"timer\";i:1268280187;}'
WHERE session_id='f7394325c31421adcc5f268e2b36b610'
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 id
FROM jos_core_acl_aro_groups
WHERE name = ''
SELECT `file`, `params`
FROM `jos_sefexts`
SELECT *
FROM jos_sefurls
WHERE ((`sefurl` = 'component/remository/Dini---Manevi/ISLAM-AKAiDi.rar') OR (`sefurl` = 'component/remository/Dini---Manevi/ISLAM-AKAiDi.rar/'))
AND (`origurl` != '')
ORDER BY `priority`
LIMIT 1
SELECT *
FROM `jos_sefmoved`
WHERE (`old` = 'component/remository/Dini---Manevi/ISLAM-AKAiDi.rar') OR (`old` = 'component/remository/Dini---Manevi/ISLAM-AKAiDi.rar/')
SELECT *
FROM jos_downloads_repository
ORDER BY id
LIMIT 1
SELECT *
FROM jos_downloads_containers
ORDER BY sequence, name
SELECT f.id, f.containerid, f.filetitle, f.realname
FROM jos_downloads_files AS f
WHERE f.containerid = 3
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT role, subject_id, action
FROM jos_permissions
WHERE subject_type = 'remosFolder'
AND action IN('download','edit')
SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count
FROM jos_downloads_files AS f
LEFT JOIN jos_downloads_log AS l
ON l.type=3
AND l.fileid=f.id
WHERE f.id = 13
AND published=1
GROUP BY f.id
SELECT COUNT(*)
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='download' OR `action`='*')
SELECT `role`, `control`, `subject_id`, `action`
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='download' OR `action`='*')
SELECT fileid, COUNT(fileid) AS number
FROM jos_downloads_log
WHERE type = 1
AND ipaddress = '38.107.191.85'
AND date > SUBDATE(NOW(), INTERVAL 24 HOUR)
GROUP BY fileid
SELECT id
FROM jos_downloads_files
WHERE (submitdate > '2009-09-09 07:12:46' OR ('2009-09-09 07:12:46' = submitdate
AND id < 13))
ORDER BY submitdate DESC, id DESC
LIMIT 1
SELECT id
FROM jos_downloads_files
WHERE (submitdate < '2009-09-09 07:12:46' OR ('2009-09-09 07:12:46' = submitdate
AND id > 13))
ORDER BY submitdate DESC, id
LIMIT 1
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT COUNT(*)
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='edit' OR `action`='*')
SELECT `role`, `control`, `subject_id`, `action`
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='edit' OR `action`='*')
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_remository.xml'
LIMIT 1
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT *
FROM jos_users
WHERE id = '62'
SELECT c.id, c.title, c.comment, c.date, u.id AS userid, u.name, u.username
FROM jos_downloads_reviews AS c
INNER JOIN jos_users AS u
ON c.userid=u.id
WHERE c.itemid=13
SELECT c.*, CASE WHEN c.type = '' THEN 0 ELSE 9 END AS typseq
FROM jos_downloads_classify AS c
INNER JOIN jos_downloads_file_classify AS fc
ON c.id = fc.classify_id
WHERE c.published != 0
AND c.hidden = 0
AND fc.file_id = 13
ORDER BY typseq, c.name
SELECT menutype, id, name, link
FROM jos_menu
WHERE id = 0
AND link LIKE '%com_remository%'
SELECT *
FROM jos_ijseo_metags
WHERE id = 0
AND name = ''
SELECT *
FROM jos_ijseo_metags
WHERE id = 0
AND name = ''
SELECT *
FROM jos_ijseo_metags
WHERE id = 13
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_ijseo_metags
WHERE id = 13
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_menu
WHERE home = '1'
ORDER BY ordering
LIMIT 1
