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