SELECT *
FROM jos_session
WHERE session_id = 'hqpr05prcrt03p033812m04va7'
DELETE
FROM jos_session
WHERE ( TIME < '1328433503' )
SELECT *
FROM jos_session
WHERE session_id = 'hqpr05prcrt03p033812m04va7'
UPDATE `jos_session`
SET `time`='1328434403',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1328434167;s:18:\"session.timer.last\";i:1328434362;s:17:\"session.timer.now\";i:1328434382;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:67:\"/home1/realetg1/public_html/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:{}}}'
WHERE session_id='hqpr05prcrt03p033812m04va7'
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 `file`, `params`
FROM `jos_sefexts`
SELECT *
FROM jos_xmap
SELECT *
FROM jos_menu
WHERE id = '195'
SELECT *
FROM `jos_xmap_sitemap`
WHERE id=1
SELECT *
FROM jos_xmap_items
WHERE VIEW='html'
AND sitemap_id=1
SELECT *
FROM `jos_xmap_ext`
WHERE `published`=1
AND extension NOT LIKE '%.bak'
SELECT *
FROM jos_menu
WHERE id = '195'
SELECT *
FROM jos_modules
WHERE published='1'
AND module ='mod_mainmenu'
AND params LIKE '%menutype=site-map%'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=0
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_content.xml'
LIMIT 1
SELECT `catid`
FROM `jos_content`
WHERE `id` = '5'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=5&view=article'
SELECT c.title AS category, c.id AS category_id, a.title AS title, a.introtext AS item_desc, a.id
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON a.catid = c.id
WHERE a.id = 5
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=5&view=article'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=204
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '57'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=197
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '58'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=198
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '59'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=199
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=200
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=201
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_blog.xml'
LIMIT 1
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=196
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=203
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '61'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=61&view=article'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=33
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '52'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=205
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=206
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '54'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=208
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '55'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=209
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '56'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=213
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=214
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT `catid`
FROM `jos_content`
WHERE `id` = '66'
SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.TYPE='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=215
AND m.menutype = 'site-map'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
UPDATE jos_xmap_sitemap
SET `name`='New Sitemap',`expand_category`='0',`expand_section`='0',`show_menutitle`='0',`columns`='1',`exlinks`='1',`ext_image`='img_grey.gif',`menus`='site-map,0,1,1,0.5,daily,',`exclmenus`='',`includelink`='0',`usecache`='0',`cachelifetime`='15',`classname`='xmap',`count_xml`='0',`count_html`='16',`views_xml`='0',`views_html`='1337',`lastvisit_xml`='0',`lastvisit_html`='1328434403',`excluded_items`='',`compress_xml`='0'
WHERE id=1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 195)
ORDER BY menuid DESC
LIMIT 0, 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 = 195 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
