SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
DELETE
FROM jos_session
WHERE ( time < '1268279079' )
SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
UPDATE `jos_session`
SET `time`='1268279979',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1268279880;s:18:\"session.timer.last\";i:1268279880;s:17:\"session.timer.now\";i:1268279880;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:{}}}aliro_auth|a:5:{s:10:\"subj_found\";a:1:{s:11:\"remosFolder\";a:2:{s:8:\"download\";a:1:{s:1:\"*\";i:1268279881;}s:4:\"edit\";a:20:{s:1:\"*\";i:1268279881;i:1;i:1268279881;i:10;i:1268279881;i:11;i:1268279881;i:12;i:1268279881;i:13;i:1268279881;i:14;i:1268279881;i:15;i:1268279881;i:16;i:1268279881;i:17;i:1268279881;i:18;i:1268279881;i:19;i:1268279881;i:2;i:1268279881;i:3;i:1268279881;i:4;i:1268279881;i:5;i:1268279881;i:6;i:1268279881;i:7;i:1268279881;i:8;i:1268279881;i:9;i:1268279881;}}}s:11:\"permissions\";a:1:{s:11:\"remosFolder\";a:1:{s:4:\"edit\";a:19:{i:1;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:10;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:11;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:12;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:13;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:14;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:15;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:16;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:17;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:18;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:19;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:2;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:3;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:4;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:5;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:6;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:7;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:8;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:9;a:1:{s:6:\"Nobody\";s:1:\"2\";}}}}s:12:\"access_found\";a:1:{s:5:\"aUser\";a:1:{i:62;i:1268279881;}}s:12:\"access_roles\";a:0:{}s:5:\"timer\";i:1268279881;}'
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/Eğitim/Dil-Ögretiminde-Yaklaşim-Ve-Yöntem-Tartismasi---Anonim.Rar') OR (`sefurl` = 'component/remository/Eğitim/Dil-Ögretiminde-Yaklaşim-Ve-Yöntem-Tartismasi---Anonim.Rar/'))
AND (`origurl` != '')
ORDER BY `priority`
LIMIT 1
SELECT *
FROM `jos_sefmoved`
WHERE (`old` = 'component/remository/Eğitim/Dil-Ögretiminde-Yaklaşim-Ve-Yöntem-Tartismasi---Anonim.Rar') OR (`old` = 'component/remository/Eğitim/Dil-Ögretiminde-Yaklaşim-Ve-Yöntem-Tartismasi---Anonim.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 = 5
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 = 26
AND published=1
GROUP BY f.id
SELECT fileid, COUNT(fileid) AS number
FROM jos_downloads_log
WHERE type = 1
AND ipaddress = '38.107.191.87'
AND date > SUBDATE(NOW(), INTERVAL 24 HOUR)
GROUP BY fileid
SELECT id
FROM jos_downloads_files
WHERE (submitdate > '2009-09-09 07:17:00' OR ('2009-09-09 07:17:00' = submitdate
AND id < 26))
ORDER BY submitdate DESC, id DESC
LIMIT 1
SELECT id
FROM jos_downloads_files
WHERE (submitdate < '2009-09-09 07:17:00' OR ('2009-09-09 07:17:00' = submitdate
AND id > 26))
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 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=26
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 = 26
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 = 26
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_ijseo_metags
WHERE id = 26
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_menu
WHERE home = '1'
ORDER BY ordering
LIMIT 1
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&view=frontpage'
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_content.xml'
LIMIT 1
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=48&view=category'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=51&view=category'
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_alphacontent.xml'
LIMIT 1
SELECT `catid`
FROM `jos_content`
WHERE `id` = '46'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=50&view=category'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=47&view=category'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '179'
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_contact.xml'
LIMIT 1
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 = 0 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_googleSearch_conf
LIMIT 1
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_googlesearch%'
LIMIT 1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND catid = 14
ORDER BY sticky DESC, ordering
LIMIT 0, 7
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 14
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_banners.xml'
LIMIT 1
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=14&task=click'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 37
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 13
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=13&task=click'
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 = 12
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=12&task=click'