Since we are going to be doing much more communicating electronically, we need to make sure we have your most current email address. First of all, login to the website. In the event that you change your email, please remember to update your information by using the "Your Details" button in the "Members Only Menu". Here you can upload a photo of yourself and update your contact information. You may edit your contact information at any time. If you are not logged in yet, please login.
Hotel Information
NATS Official CONTRACTED Lodging
UPDATED HOTEL INFORMATION WILL BE POSTED SUMMER 2008
Please make note of cut-off dates when making lodging plans and remember to mention NATS for these excellent rates. It takes about twenty minutes to drive from the Holiday Inn, La Quinta and Marriott Hotels. The Hotel Lumen is directly in front of the Music Building and all activities. The Radisson is within walking distance but buses are available to campus from the DART station just behind the hotel.
1
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering2
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`ordering`='1') AND (`parent` = 0) AND (`access` >= '0'))3
SELECT id FROM jos_mambots WHERE element = 'joomsef_metabot' AND folder = 'system' AND published = 14
SELECT * FROM jos_redirection WHERE oldurl = '' OR oldurl = 'index.php' LIMIT 15
SELECT id, link
FROM jos_menu
WHERE menutype = 'mainmenu'
AND published = 1
ORDER BY parent, ordering
LIMIT 16
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 17
DELETE FROM jos_session
WHERE (
( time < '1215369158' )
AND guest = 0
AND gid > 0
) OR (
( time < '1215369158' )
AND guest = 1
AND userid = 0
)8
SELECT id FROM jos_mambots WHERE element = 'joomsef_metabot' AND folder = 'system'9
SELECT *
FROM jos_mambots
WHERE id = '20'10
SELECT *
FROM jos_menu
WHERE id = 111
SELECT COUNT(a.id)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-07-06 11:47' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-06 11:47' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 012
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-07-06 11:47' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-06 11:47' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0
ORDER BY f.ordering
LIMIT 613
SELECT DATABASE()14
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=63'15
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 6316
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=63&task=view'17
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering18
SELECT DATABASE()19
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=72'20
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 7221
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=72&task=view'22
SELECT DATABASE()23
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=139'24
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 13925
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=139&task=view'26
SELECT params
FROM jos_mambots
WHERE element = 'mosemailcloak'
AND folder = 'content'27
SELECT DATABASE()28
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12'29
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 1230
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=12&task=view'31
SELECT DATABASE()32
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=56'33
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 5634
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=56&task=view'35
SELECT DATABASE()36
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=42'37
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 4238
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=42&task=view'39
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1 )
ORDER BY ordering40
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'41
SELECT DATABASE()42
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering43
SELECT DATABASE()44
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_contact'45
SELECT DATABASE()46
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1'47
SELECT title AS section, `id` FROM jos_sections WHERE id = 148
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=1&task=section'49
SELECT DATABASE()50
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_weblinks&catid=2'51
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering52
SELECT DATABASE()53
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_frontpage'54
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_frontpage'55
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 156
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=12'57
SELECT DATABASE()58
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12'59
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 1260
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=12&task=view'61
SELECT DATABASE()62
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_weblinks'63
SELECT DATABASE()64
SELECT DATABASE()65
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_joomlaboard'66
SELECT DATABASE()67
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap'68
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering69
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
LEFT JOIN jos_categories AS cc ON cc.id = a.catid
LEFT JOIN jos_sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-07-06 11:47' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-06 11:47' )
AND a.access <= 0
AND f.content_id IS NULL
ORDER BY a.created DESC
LIMIT 570
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 143
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id71
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 072
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 073
SELECT DATABASE()74
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=143'75
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 14376
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=143&task=view'77
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 142
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id78
SELECT DATABASE()79
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=142'80
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 14281
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=142&task=view'82
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 137
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id83
SELECT DATABASE()84
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=137'85
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 13786
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=137&task=view'87
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 96
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id88
SELECT DATABASE()89
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=96'90
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 9691
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=96&task=view'92
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 115
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id93
SELECT DATABASE()94
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=115'95
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 11596
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=115&task=view'97
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
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 <= '2008-07-06 11:47' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-06 11:47' )
AND a.catid = 3
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering98
SELECT DATABASE()99
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=58'100
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 58101
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=58&task=view'102
SELECT params
FROM jos_mambots
WHERE element = 'mosimage'
AND folder = 'content'103
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1104
SELECT DATABASE()105
SELECT DATABASE()106
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&task=lostPassword'107
SELECT DATABASE()108
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&task=register'109
SELECT DATABASE()110
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 (NOT ( a.usertype is NULL OR a.usertype = '' ))
ORDER BY a.username ASC111
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'othermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering112
SELECT DATABASE()113
SELECT DATABASE()114
SELECT DATABASE()115
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=blogsection&id=5'116
SELECT title AS section, `id` FROM jos_sections WHERE id = 5117
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=5&task=blogsection'118
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=50'119
SELECT DATABASE()120
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=50'121
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 50122
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=50&task=view'123
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=45'124
SELECT DATABASE()125
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=45'126
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 45127
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=45&task=view'128
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=42'129
SELECT DATABASE()130
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=42'131
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 42132
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=42&task=view'133
SELECT DATABASE()134
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=blogcategory&id=28'135
SELECT s.title AS section, s.id FROM jos_categories as c LEFT JOIN jos_sections AS s ON c.section = s.id WHERE c.id = 28136
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=28&task=blogcategory'137
SELECT DATABASE()138
SELECT DATABASE()139
SELECT DATABASE()140
SELECT DATABASE()141
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_contact&task=view&contact_id=1'142
SELECT name, id FROM jos_menu WHERE link = 'index.php?option=com_contact'143
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_contact&contact_id=1&task=view'144
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-07-06 11:47' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-06 11:47' )
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 5145
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 33
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id146
SELECT DATABASE()147
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=33'148
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 33149
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=33&task=view'150
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 42
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id151
SELECT DATABASE()152
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=42'153
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 42154
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=42&task=view'155
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 12
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id156
SELECT DATABASE()157
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12'158
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 12159
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=12&task=view'160
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 46
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id161
SELECT DATABASE()162
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=46'163
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 46164
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=46&task=view'165
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 47
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id166
SELECT DATABASE()167
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=47'168
SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 47169
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=47&task=view'170
SELECT DATABASE()