Rutgers Home Login to this Site Search Rutgers Search All of SC&I Directory News & Events Content Courses Blogs Personal Web Pages Placement All of Rutgers for   Home About SC&I About SC&I Faculty and Student Accomplishments Contact SC&I Visit SC&I Academics View All SC&I Courses Undergraduate Programs Communication Major Information Technology and Informatics Major Journalism and Media Studies Major Graduate Programs Master of Communication and Information Studies Master of Library and Information Science Ph.D. Program Continuing Education Professional Development Continuing Education Program Current & Prospective Students Current Students Prospective Students Student Life Alumni & Friends Supporting SC&I SC&I Development and Public Communications Office SC&I Alumni Friends of SC&I Supporting Rutgers Directory All Faculty and Staff Department of Communication Department of Journalism and Media Studies Department of Library and Information Science Dean's Office and IT Staff Research Support Staff Doctoral Students Communication Journalism and Media Studies Library and Information Science Professional Development Studies Welcome from the Dean Welcome to the School of Communication and Information at Rutgers. Here is where students interested in careers in journalism, media, public relations, information science, libraries, government, and business communication come to study with one of the nation's leading interdisciplinary research faculties. We are committed to meeting the challenges of the future -- challenges to which communication and information are central. Read more >> Communication The Department of Communication teaches about the nature and effects of communication on the individual, social groups and society.  We emphasize theories about communication processes that involve messages, meanings and media.  We also investigate a variety of ways in which communication is practiced in everyday life ... More about Communication >> Library & Information Science Information and you - a powerful but complex relationship. The Department of Library and Information Science makes this relationship our focus.You will learn to lead in information rich contexts and systems: from knowledge management to children's literature; from digital libraries to information technology and... More about Library & Information Science >> Journalism & Media Studies The Department of Journalism and Media Studies concerns itself with both the practice of journalism and media production as well as the analysis of media institutions in a democratic society. We stand out among other journalism programs in our emphasis on both theory and practice, grounding our students in a rigorous, ... More about Journalism & Media Studies >> Professional Development Studies Professional Development Studies is the off campus outreach and continuing education program of the School of Communication and Information. We offer a variety of certificate programs designed to help you update or expand your professional skills and interests, enable a salary lane change, meet licensing requirements, ... More about Professional Development Studies >> Blog Posts from the SC&I Community February 8th, 2010 / 12:22 am Craig R. Scott From the Director’s Deck: What Are the Odds??? February 6th, 2010 / 12:38 pm Claire R. McInerney Rutgers SC&I faculty member and students win top prize at the I-conference February 3rd, 2010 / 1:39 pm Jessica Lingel Upcoming discussions hosted by Rad Ref NYC January 26th, 2010 / 2:46 pm Tom Davis Feb. 5. WORKSHOP in Room 119/Mobile journalism in a digital age: Carrying a newsroom in your bag January 24th, 2010 / 9:32 pm Richard Lee The New NJ Governor and Higher Ed December 21st, 2009 / 1:17 pm Peter Hercky Public Info on PR & Comm.: If you don't get picked up, don't kvetch, vitch! December 17th, 2009 / 12:54 pm GraceAnne Andreassi DeCandido Ten Things in American Libraries December 5th, 2009 / 1:43 am Marija Dalbello Lia Ungureanu presents The Family Album in the Era of its Digital Reproduction Contact SC&I School of Communication and Information Rutgers, The State University of New Jersey Voice: (732) 932-7500 ext. 8000 Fax: (732) 932-6916 4 Huntington Street New Brunswick, NJ 08901 IT Services Helpdesk (732) 932-7500 ext. 8999 help@comminfo.rutgers.edu  More Contact Information >> Faculty/Staff:  RCI Webmail | RULink Webmail | Website Login Apply to SC&I Undergraduate admissions >> Graduate admissions >> News Preventing Risky Behavior in Short Order: $450,000 to Improve Anti-Abuse Programs SC&I Director Receives Preservation Management Scholarship Spring Lectures at The School of Communication and Information Rutgers Team Works to Improve Trauma Care Communication Major: "How I Beat the Transfer Blues" SC&I Scholarship Recipients Meet Donors Who Support Their Academic Work See More News >> Events February 10, 2010 CANCELLED: Johnson & Johnson Blue Ribbon Health and Medical Speakers Series: Engaging Individuals and Communities for HIV Prevention Work in Sub-Saharan Africa February 10, 2010 Making Democracy Work through Information and Communication Technologies: A Case of the Kentucky Citizen Media Project – The Lexington Commons February 12, 2010 Xiaomu Zhou: Computerization of Medical Records February 16, 2010 AWC Presents Jennifer Garibay-Weiss See more Events >> See Event Calendar >> Placement Services Most Recent Job Postings: January 12th, 2010 Associate Director/Coordinator for Education & Instruction January 6th, 2010 Human Rights Communications Internship January 6th, 2010 Digital Initiatives Librarian More from Placement Services » Centers, Institutes, & Affiliates Center for Communication and Health Issues Center for Interdisciplinary Studies in Information Privacy and Security (ISIPS) Center for International Scholarship in School Libraries (CISSL) Center for Media Studies Center for Mobile Communication Studies Invitational Masters Student Institute Journalism Resources Institute Knowledge Institute LAIR Laboratory New Jersey Center for the Book New Jersey Communication Association Organizational Development and Leadership (ODL) Retired Faculty Association Rutgers University Council on Children's Literature SC&I Alumni Association Silver Knights Faculty/Staff Login Copyright © 2010 Rutgers, the State University of New Jersey. All Rights Reserved.

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT sef.querystring 
 FROM jos_scilssef sef 
 WHERE sef.url = 'facstaff/profile/'
4
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
5
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
6
DELETE FROM jos_session
 WHERE (
 ( time < '1265746141' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265766841' )
 AND guest = 1
 AND userid = 0
 )
7
SELECT *
 FROM jos_session
 WHERE session_id = '5a95fc5ca959a0f5a7a4ae1579a03580'
8
SELECT session_id
 FROM jos_session
 WHERE session_id = '25d81286a8cecb571138868c5ad87c20'
9
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '25d81286a8cecb571138868c5ad87c20','1265767741','','0','1' )
10
SELECT *
 FROM jos_menu
 WHERE id = 1
11
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 <= '2010-02-09 21:09' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 21:09' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
12
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 <= '2010-02-09 21:09' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 21:09' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
13
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'
14
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 ordering
15
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'
16
SELECT ctx.id, ctx.context, ctx.selected, ctx.quicklink, ctx.quicklinkonly 
 FROM jos_scilssearch ctx 
 ORDER BY ordering
17
SELECT m.* FROM jos_menu AS m WHERE menutype='General Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
18
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
19
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=50'
20
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
21
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=50'
 AND NOT (params LIKE '%unique_itemid=0%')
22
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 = 50
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
23
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=50&option=com_content&task=view'
24
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=50&option=com_content&task=view'
25
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
26
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
 AND NOT (params LIKE '%unique_itemid=0%')
27
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 = 55
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=55&option=com_content&task=view'
29
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=601'
30
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=601'
 AND NOT (params LIKE '%unique_itemid=0%')
31
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 = 601
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=601&option=com_content&task=view'
33
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2632&id=39&option=com_content&task=view'
34
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=243'
35
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=243'
 AND NOT (params LIKE '%unique_itemid=0%')
36
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=54&id=243&option=com_content&task=view'
37
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
38
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
 AND NOT (params LIKE '%unique_itemid=0%')
39
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.id
40
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2608&id=12&option=com_content&task=view'
41
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
 AND NOT (params LIKE '%unique_itemid=0%')
43
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 = 13
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2609&id=13&option=com_content&task=view'
45
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
 AND NOT (params LIKE '%unique_itemid=0%')
47
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 = 14
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2610&id=14&option=com_content&task=view'
49
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=704'
50
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=704'
 AND NOT (params LIKE '%unique_itemid=0%')
51
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 = 704
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
52
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2611&id=704&option=com_content&task=view'
53
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
54
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
 AND NOT (params LIKE '%unique_itemid=0%')
55
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 = 16
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
56
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2612&id=16&option=com_content&task=view'
57
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=992'
58
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=992'
 AND NOT (params LIKE '%unique_itemid=0%')
59
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2768&id=992&option=com_content&task=view'
60
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=128'
61
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=128'
 AND NOT (params LIKE '%unique_itemid=0%')
62
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 = 128
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
63
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2614&id=128&option=com_content&task=view'
64
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=600'
65
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=600'
 AND NOT (params LIKE '%unique_itemid=0%')
66
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=78&id=600&option=com_content&task=view'
67
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=581'
68
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=581'
 AND NOT (params LIKE '%unique_itemid=0%')
69
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 = 581
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
70
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=581&option=com_content&task=view'
71
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=592'
72
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=592'
 AND NOT (params LIKE '%unique_itemid=0%')
73
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 = 592
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
74
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2702&id=592&option=com_content&task=view'
75
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=921'
76
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=921'
 AND NOT (params LIKE '%unique_itemid=0%')
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 = 921
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
78
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=921&option=com_content&task=view'
79
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=187&option=com_content&task=view'
80
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=603&option=com_content&task=view'
81
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=604&option=com_content&task=view'
82
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=605&option=com_content&task=view'
83
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=625'
84
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=625'
 AND NOT (params LIKE '%unique_itemid=0%')
85
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 = 625
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
86
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2741&id=625&option=com_content&task=view'
87
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=38&option=com_content&task=view'
88
SELECT m.* FROM jos_menu AS m WHERE menutype='Departmental Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
89
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=124&id=76&option=com_content&task=view'
90
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=125&id=86&option=com_content&task=view'
91
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&id=87&option=com_content&task=view'
92
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=127&id=135&option=com_content&task=view'
93
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'welcome'
94
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '0' AND c.metakey REGEXP '(^|,)[[:space:]]*welcome[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0
95
SELECT c.*, u.name as authorname, cb.avatar, 'content' as itemtype 
 FROM jos_content c, jos_users u, jos_comprofiler cb 
 WHERE u.id = c.created_by 
 AND u.id = cb.user_id 
 AND c.catid = '29' 
 AND c.sectionid = '6' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*welcome[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC
96
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=834'
97
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=834'
 AND NOT (params LIKE '%unique_itemid=0%')
98
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 = 834
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=834&option=com_content&task=view'
100
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, 'topitem, welcome') 
LIMIT 1
101
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=390'
102
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'comm department'
103
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '38' AND c.metakey REGEXP '(^|,)[[:space:]]*comm department[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0
104
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
105
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
106
SELECT *
 FROM jos_mambots
 WHERE id = '23'
107
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=124&id=76&option=com_content&task=view'
108
SELECT c.*, u.name as authorname, cb.avatar, 'content' as itemtype 
 FROM jos_content c, jos_frontmoderator m, jos_tagvocabulary t, jos_users u, jos_comprofiler cb 
 WHERE u.id = c.created_by 
 AND u.id = cb.user_id 
AND t.tagname = 'comm department' AND t.id = m.approvedTag AND m.approved = 1 AND m.contentId = c.id 
 AND c.sectionid = '9' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*comm department[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0 
 ORDER BY m.dateStatusSet DESC 
 LIMIT 1
109
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=76'
110
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=76'
 AND NOT (params LIKE '%unique_itemid=0%')
111
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=124&id=76&option=com_content&task=view'
112
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=77'
113
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'lis department'
114
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '38' AND c.metakey REGEXP '(^|,)[[:space:]]*lis department[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0
115
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
116
SELECT *
 FROM jos_mambots
 WHERE id = '23'
117
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&id=87&option=com_content&task=view'
118
SELECT c.*, u.name as authorname, cb.avatar, 'content' as itemtype 
 FROM jos_content c, jos_frontmoderator m, jos_tagvocabulary t, jos_users u, jos_comprofiler cb 
 WHERE u.id = c.created_by 
 AND u.id = cb.user_id 
AND t.tagname = 'lis department' AND t.id = m.approvedTag AND m.approved = 1 AND m.contentId = c.id 
 AND c.sectionid = '9' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*lis department[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0 
 ORDER BY m.dateStatusSet DESC 
 LIMIT 1
119
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=87'
120
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=87'
 AND NOT (params LIKE '%unique_itemid=0%')
121
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&id=87&option=com_content&task=view'
122
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=77'
123
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'journalism department'
124
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '38' AND c.metakey REGEXP '(^|,)[[:space:]]*journalism department[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0
125
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
126
SELECT *
 FROM jos_mambots
 WHERE id = '23'
127
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=125&id=86&option=com_content&task=view'
128
SELECT c.*, u.name as authorname, cb.avatar, 'content' as itemtype 
 FROM jos_content c, jos_frontmoderator m, jos_tagvocabulary t, jos_users u, jos_comprofiler cb 
 WHERE u.id = c.created_by 
 AND u.id = cb.user_id 
AND t.tagname = 'journalism department' AND t.id = m.approvedTag AND m.approved = 1 AND m.contentId = c.id 
 AND c.sectionid = '9' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*journalism department[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0 
 ORDER BY m.dateStatusSet DESC 
 LIMIT 1
129
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=86'
130
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=86'
 AND NOT (params LIKE '%unique_itemid=0%')
131
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=125&id=86&option=com_content&task=view'
132
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=127'
133
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'pds program'
134
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '38' AND c.metakey REGEXP '(^|,)[[:space:]]*pds program[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0
135
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
136
SELECT *
 FROM jos_mambots
 WHERE id = '23'
137
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=127&id=135&option=com_content&task=view'
138
SELECT c.*, u.name as authorname, cb.avatar, 'content' as itemtype 
 FROM jos_content c, jos_frontmoderator m, jos_tagvocabulary t, jos_users u, jos_comprofiler cb 
 WHERE u.id = c.created_by 
 AND u.id = cb.user_id 
AND t.tagname = 'pds program' AND t.id = m.approvedTag AND m.approved = 1 AND m.contentId = c.id 
 AND c.sectionid = '9' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*pds program[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0 
 ORDER BY m.dateStatusSet DESC 
 LIMIT 1
139
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=135'
140
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=135'
 AND NOT (params LIKE '%unique_itemid=0%')
141
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=127&id=135&option=com_content&task=view'
142
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=63'
143
SELECT DISTINCT c.*, u.name as authorname, cb.avatar, 'content' as itemtype 
 FROM jos_content c, jos_users u, jos_comprofiler cb 
 WHERE u.id = c.created_by 
 AND u.id = cb.user_id 
 AND c.catid = '36' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 AND c.access <= 0 
 AND DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= c.created 
 ORDER BY c.created DESC
144
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1119&option=com_content&task=view'
145
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, 'phd program') 
LIMIT 1
146
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=98'
147
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1118&option=com_content&task=view'
148
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
149
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=170'
150
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1116&option=com_content&task=view'
151
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
152
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=505'
153
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1110&option=com_content&task=view'
154
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
155
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=136'
156
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1107&option=com_content&task=view'
157
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
158
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=228'
159
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1039&option=com_content&task=view'
160
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
161
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=112'
162
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1035&option=com_content&task=view'
163
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
164
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=213'
165
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1023&option=com_content&task=view'
166
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
167
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=161'
168
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
169
SELECT *
 FROM jos_mambots
 WHERE id = '23'
170
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'
171
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
172
SELECT *
 FROM jos_mambots
 WHERE id = '23'
173
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2603&id=137&option=com_content&task=view'
174
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2603&id=138&option=com_content&task=view'
175
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
176
SELECT *
 FROM jos_mambots
 WHERE id = '23'
177
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=603&option=com_content&task=view'
178
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
179
SELECT *
 FROM jos_mambots
 WHERE id = '23'
180
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'option=com_news&task=list'
181
SELECT DISTINCT c.*, 'content' as itemtype 
 FROM jos_content c 
 WHERE c.state = '1' 
 AND c.catid = '64' 
 AND c.sectionid = '14' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:09:01' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:09:01' ) 
 ORDER BY c.ordering ASC 
 LIMIT 6
182
SELECT id FROM jos_rd_rss 
 WHERE params LIKE '%item_type=news%' 
 LIMIT 1
183
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1117'
184
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1117'
 AND NOT (params LIKE '%unique_itemid=0%')
185
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 = 1117
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
186
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
187
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1117&option=com_news&task=single'
188
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1113'
189
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1113'
 AND NOT (params LIKE '%unique_itemid=0%')
190
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 = 1113
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
191
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1113&option=com_news&task=single'
192
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=739'
193
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=739'
 AND NOT (params LIKE '%unique_itemid=0%')
194
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 = 739
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
195
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=739&option=com_news&task=single'
196
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1025'
197
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1025'
 AND NOT (params LIKE '%unique_itemid=0%')
198
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 = 1025
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
199
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1025&option=com_news&task=single'
200
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1021'
201
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1021'
 AND NOT (params LIKE '%unique_itemid=0%')
202
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 = 1021
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
203
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1021&option=com_news&task=single'
204
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1012'
205
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1012'
 AND NOT (params LIKE '%unique_itemid=0%')
206
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 = 1012
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
207
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1012&option=com_news&task=single'
208
SELECT b.date_event, b.date_start, b.title, b.event_id, b.tags 
 FROM jos_events b 
 WHERE b.published = 1 AND b.date_expire >= now() 
 ORDER BY b.date_event ASC, b.date_expire ASC  LIMIT 4
209
SELECT id FROM jos_rd_rss 
 WHERE params LIKE '%item_type=events%' 
 LIMIT 1
210
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=500&option=com_events&task=single'
211
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=519&option=com_events&task=single'
212
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=517&option=com_events&task=single'
213
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=507&option=com_events&task=single'
214
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'option=com_events&task=list'
215
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'option=com_events&task=calendar'
216
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
217
SELECT *
 FROM jos_mambots
 WHERE id = '23'
218
SELECT id FROM jos_mambots WHERE element = 'mosmodule' AND folder = 'content'
219
SELECT *
 FROM jos_mambots
 WHERE id = '22'
220
SELECT DISTINCT position from jos_modules ORDER BY position
221
SELECT P.`date_posted`, P.`positionID`, P.`job_title` FROM Positions P, Employers E WHERE E.employerID=P.EmployerID AND P.`display` = 1 ORDER BY P.`positionID` DESC LIMIT 0,3;
222
SELECT l.* 
 FROM jos_weblinks l
 WHERE 1=1 
 AND l.catid = '39' 
 ORDER BY l.title ASC
223
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'