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 LIS Programs ITI Major >> Masters Program (MLIS) >> Doctoral Program >> LIS Faculty All Faculty >> Core Faculty >> Adjunct Faculty >> Affiliated Faculty >> Emeritus Faculty >> Teaching Assistants >> Research Assistants >> Library and Information Science Department 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 informatics; from information interfaces and economics to the design and evaluation of information, information services, and information agencies. Our Master's degree program ranks sixth in the nation, according to U.S. News and World Report, drawing students to both its campus in New Brunswick, NJ and to its online options. Our undergraduates are in high demand by employers seeking people who can manage information systems for the benefit of their human users. Our PhD program concentration in LIS features in depth study in Information Science and Library Science. It prepares graduates to become professors in highly ranked LIS schools, leaders in the library profession, and researchers in the information technology industry. Click here to find out more about the LIS PhD concentration , the LIS core faculty and our interdisciplinary PhD program. The graduates from all of our degree programs and certificate programs find employment in traditional professional roles and in many high-tech industries and organizations. See what we have to offer you!   LIS Faculty Personal Blog Posts 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 31st, 2010 / 4:23 pm Claire R. McInerney Lost Knowledge - What happens when workers leave an organization? January 27th, 2010 / 12:17 pm Jessica Lingel Librarian stereotypes transcend musical genres? Apply to SC&I Undergraduate admissions >> Graduate admissions >> LIS News SC&I Director Receives Preservation Management Scholarship Spring Lectures at The School of Communication and Information Rutgers Team Works to Improve Trauma Care SC&I Scholarship Recipients Meet Donors Who Support Their Academic Work Not Your Mother’s Library: Reference Experts Write for the 21st Century MLIS Alumna Works With Papers of George Segal at Princeton Mobile Communication and Social Policy: An International Conference Michael Moore Tips His (Rutgers) Hat to Library Science Alumna The "Informers" and the "Meformers": Study Reveals Two Types of Twitter Users Journalism Major Interviews Rutgers President McCormick About Annual Address for RU-tv Professor Nicholas Belkin Receives Distinguished Lectureship Award from NJ/ASIS&T MLIS Students Explore Italian Libraries and Meet Scholars from around the World School of Communication and Information Welcomes Four New Faculty Members Doctoral Alumna Wins Prestigious Teaching Award at Syracuse University's iSchool HP Award Enables Greater Classroom Interaction, Sheds Light on Laptop Use What is Knowledge Management? New Video Illuminates an Increasingly Important Field whereRU: Convocation Captured Using New Imaging Technology SC&I Hosts First Alumni Event During Rutgers Reunion Weekend Library and Information Science Again Receives Top Rankings from US News and World Report Graduate Students and Faculty Receive Awards at First Ever Honors Day Student Project Allows Anyone to See Rutgers Up Close and Personal Researchers Win Google Award to Study Search Process First Social Media Class at Rutgers Open for Registration Professional Development Studies Director Cited for Online Education Excellence Five Books by SCILS Professors Honored in Celebration of Rutgers Faculty Authors Spring Contests for Undergraduates in Public Speaking, Writing (Deadline Extended) SCILS Alumnus Tim Pernetti Named Rutgers Director of Intercollegiate Athletics See More Library and Information Science Department News >> LIS Events February 12, 2010 Xiaomu Zhou: Computerization of Medical Records February 16, 2010 LIS Distinguished Speaker Series: Jamshid Beheshti February 17, 2010 Departmental and Administrative Meetings February 18, 2010 "Challenges of a Changing Workforce" Conference February 24, 2010 School of Communication and Information Faculty Meeting February 26, 2010 Research @ SC&I: When Do You Need Human Subjects Review? See more Library and Information Science Department Events >> See Library and Information Science Department Event Calendar >> Contact Information Department of Library and Information Science Rutgers, the State University of New Jersey 4 Huntington St. New Brunswick, NJ 08901-1071 732-932-7500 Fax: 732-932-6916 lis@scils.rutgers.edu Library and Information Science Centers, Institutes, & Affiliates Center for Interdisciplinary Studies in Information Privacy and Security (ISIPS) Center for International Scholarship in School Libraries (CISSL) Knowledge Institute LAIR Laboratory New Jersey Center for the Book 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 = 'library-and-information-science/library-and-information-science-department.html'
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 126 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1265734998' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265755698' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_session
 WHERE session_id = 'f8d5c833559ad32493c24b69bb3cb1a5'
7
SELECT session_id
 FROM jos_session
 WHERE session_id = 'a6c1f44c2ecd63800fc1869843d17298'
8
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'a6c1f44c2ecd63800fc1869843d17298','1265756598','','0','1' )
9
select * from jos_content where id = '87'
10
SELECT *
 FROM jos_menu
 WHERE id = 126
11
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 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.id = 87 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-09 18:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 18:03' )
 AND a.access <= 0
12
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '87'
13
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
14
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
15
SELECT *
 FROM jos_mambots
 WHERE id = '23'
16
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'
17
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 = 126 )
 ORDER BY ordering
18
SELECT u.id as authorid, u.name as authorname, c.sectionid, c.catid, s.name as sectionname, cat.name as catname 
 FROM jos_content c, jos_users u, jos_sections s, jos_categories cat 
 WHERE c.created_by = u.id 
 AND c.id = '87' AND c.sectionid = s.id AND c.catid = cat.id
19
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=77'
20
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'
21
SELECT ctx.id, ctx.context, ctx.selected, ctx.quicklink, ctx.quicklinkonly 
 FROM jos_scilssearch ctx 
 ORDER BY ordering
22
SELECT m.* FROM jos_menu AS m WHERE menutype='General Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
23
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
24
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=50'
25
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
26
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%')
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 = 50
 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=50&option=com_content&task=view'
29
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=50&option=com_content&task=view'
30
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
31
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%')
32
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
33
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=55&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=601'
35
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%')
36
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
37
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=601&option=com_content&task=view'
38
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2632&id=39&option=com_content&task=view'
39
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=243'
40
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%')
41
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=54&id=243&option=com_content&task=view'
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
43
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%')
44
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
45
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2608&id=12&option=com_content&task=view'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
47
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%')
48
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
49
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2609&id=13&option=com_content&task=view'
50
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
51
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%')
52
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
53
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2610&id=14&option=com_content&task=view'
54
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=704'
55
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%')
56
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
57
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2611&id=704&option=com_content&task=view'
58
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
59
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%')
60
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
61
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2612&id=16&option=com_content&task=view'
62
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=992'
63
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%')
64
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2768&id=992&option=com_content&task=view'
65
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=128'
66
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%')
67
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
68
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2614&id=128&option=com_content&task=view'
69
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=600'
70
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%')
71
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=78&id=600&option=com_content&task=view'
72
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=581'
73
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%')
74
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
75
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=581&option=com_content&task=view'
76
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=592'
77
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%')
78
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
79
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2702&id=592&option=com_content&task=view'
80
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=921'
81
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%')
82
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 921
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
83
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=921&option=com_content&task=view'
84
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=187&option=com_content&task=view'
85
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=603&option=com_content&task=view'
86
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=604&option=com_content&task=view'
87
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=605&option=com_content&task=view'
88
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=625'
89
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%')
90
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
91
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2741&id=625&option=com_content&task=view'
92
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=38&option=com_content&task=view'
93
SELECT m.* FROM jos_menu AS m WHERE menutype='Departmental Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
94
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=124&id=76&option=com_content&task=view'
95
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=125&id=86&option=com_content&task=view'
96
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&id=87&option=com_content&task=view'
97
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=127&id=135&option=com_content&task=view'
98
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
99
SELECT *
 FROM jos_mambots
 WHERE id = '23'
100
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2609&id=13&option=com_content&task=view'
101
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2612&id=16&option=com_content&task=view'
102
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2768&id=992&option=com_content&task=view'
103
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
104
SELECT *
 FROM jos_mambots
 WHERE id = '23'
105
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=51&option=com_comprofiler&task=usersList'
106
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=42&option=com_comprofiler&task=usersList'
107
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=43&option=com_comprofiler&task=usersList'
108
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=44&option=com_comprofiler&task=usersList'
109
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=45&option=com_comprofiler&task=usersList'
110
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=38&option=com_comprofiler&task=usersList'
111
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&listid=41&option=com_comprofiler&task=usersList'
112
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 (cb.cb_department REGEXP ('(^|[|][*][|])[::space::]*(Library and Information Science)[::space::]*([|][*][|]|$)')) 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 18:03:18' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:18' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC 
 LIMIT 4
113
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1118&option=com_content&task=view'
114
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
115
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=170'
116
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1116&option=com_content&task=view'
117
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
118
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=505'
119
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1114&option=com_content&task=view'
120
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
121
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=170'
122
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=1112&option=com_content&task=view'
123
SELECT avatar 
FROM jos_tagvocabulary 
WHERE avatar is not null and avatar != '' and FIND_IN_SET(tagname, '') 
LIMIT 1
124
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&option=com_comprofiler&task=userProfile&user=505'
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=2603&id=137&option=com_content&task=view'
128
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2603&id=138&option=com_content&task=view'
129
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
130
SELECT *
 FROM jos_mambots
 WHERE id = '23'
131
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=603&option=com_content&task=view'
132
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
133
SELECT *
 FROM jos_mambots
 WHERE id = '23'
134
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'lis department'
135
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '0' 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 18:03:18' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:18' )
136
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&option=com_news&tag=lis+department&task=list'
137
SELECT c.*, 'content' as itemtype 
 FROM jos_content c, jos_tagvocabulary t 
 WHERE t.tagname = 'lis department' 
 AND c.catid = '64' 
 AND c.sectionid = '14' 
 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 18:03:18' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:18' ) 
 ORDER BY c.ordering ASC
138
SELECT id FROM jos_rd_rss 
 WHERE params LIKE '%item_type=news%' 
 AND params LIKE '%tag=lis department%' 
 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=1113'
140
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%')
141
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
142
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
143
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1113&option=com_news&task=single'
144
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=739'
145
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%')
146
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
147
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=739&option=com_news&task=single'
148
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1025'
149
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%')
150
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1025
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
151
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1025&option=com_news&task=single'
152
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1012'
153
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%')
154
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
155
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=1012&option=com_news&task=single'
156
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=969'
157
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=969'
 AND NOT (params LIKE '%unique_itemid=0%')
158
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 = 969
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
159
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=969&option=com_news&task=single'
160
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=954'
161
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=954'
 AND NOT (params LIKE '%unique_itemid=0%')
162
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 = 954
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
163
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=954&option=com_news&task=single'
164
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=944'
165
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=944'
 AND NOT (params LIKE '%unique_itemid=0%')
166
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 = 944
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
167
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=944&option=com_news&task=single'
168
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=945'
169
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=945'
 AND NOT (params LIKE '%unique_itemid=0%')
170
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 = 945
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
171
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=945&option=com_news&task=single'
172
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=941'
173
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=941'
 AND NOT (params LIKE '%unique_itemid=0%')
174
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 = 941
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
175
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=941&option=com_news&task=single'
176
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=934'
177
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=934'
 AND NOT (params LIKE '%unique_itemid=0%')
178
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 = 934
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
179
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=934&option=com_news&task=single'
180
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=922'
181
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=922'
 AND NOT (params LIKE '%unique_itemid=0%')
182
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 = 922
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
183
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=922&option=com_news&task=single'
184
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=913'
185
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=913'
 AND NOT (params LIKE '%unique_itemid=0%')
186
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 = 913
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
187
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=913&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=888'
189
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=888'
 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 = 888
 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=888&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=881'
193
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=881'
 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 = 881
 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=881&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=843'
197
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=843'
 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 = 843
 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=843&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=810'
201
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=810'
 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 = 810
 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=810&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=808'
205
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=808'
 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 = 808
 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=808&option=com_news&task=single'
208
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=805'
209
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=805'
 AND NOT (params LIKE '%unique_itemid=0%')
210
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 = 805
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
211
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=805&option=com_news&task=single'
212
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=789'
213
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=789'
 AND NOT (params LIKE '%unique_itemid=0%')
214
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 = 789
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
215
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=789&option=com_news&task=single'
216
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=794'
217
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=794'
 AND NOT (params LIKE '%unique_itemid=0%')
218
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 = 794
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
219
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=794&option=com_news&task=single'
220
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=791'
221
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=791'
 AND NOT (params LIKE '%unique_itemid=0%')
222
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 = 791
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
223
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=791&option=com_news&task=single'
224
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=782'
225
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=782'
 AND NOT (params LIKE '%unique_itemid=0%')
226
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 = 782
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
227
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=782&option=com_news&task=single'
228
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=765'
229
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=765'
 AND NOT (params LIKE '%unique_itemid=0%')
230
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 = 765
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
231
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=765&option=com_news&task=single'
232
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=755'
233
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=755'
 AND NOT (params LIKE '%unique_itemid=0%')
234
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 = 755
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
235
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=755&option=com_news&task=single'
236
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=740'
237
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=740'
 AND NOT (params LIKE '%unique_itemid=0%')
238
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 = 740
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
239
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=740&option=com_news&task=single'
240
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=738'
241
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=738'
 AND NOT (params LIKE '%unique_itemid=0%')
242
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 = 738
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
243
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=738&option=com_news&task=single'
244
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=712'
245
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=712'
 AND NOT (params LIKE '%unique_itemid=0%')
246
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 = 712
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
247
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'article_id=712&option=com_news&task=single'
248
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'lis department'
249
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() 
 AND b.tags REGEXP '(^|,)[[:space:]]*lis department[[:space:]]*(,|$)' 
 ORDER BY b.date_event ASC, b.date_expire ASC  LIMIT 6
250
SELECT id FROM jos_rd_rss 
 WHERE params LIKE '%item_type=events%' 
 AND params LIKE '%tag=lis department%' 
 LIMIT 1
251
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=517&option=com_events&task=single'
252
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=514&option=com_events&task=single'
253
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=394&option=com_events&task=single'
254
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=495&option=com_events&task=single'
255
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=460&option=com_events&task=single'
256
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'event_id=521&option=com_events&task=single'
257
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&option=com_events&tag=lis+department&task=list'
258
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&option=com_events&tag=lis+department&task=calendar'
259
SELECT id FROM jos_mambots WHERE element = 'relateditems' AND folder = 'content'
260
SELECT *
 FROM jos_mambots
 WHERE id = '23'
261
SELECT l.* 
 FROM jos_weblinks l, jos_weblinks_tags lt 
 WHERE 1=1 
 AND l.catid = '39' 
 AND lt.linkid = l.id AND lt.metakey REGEXP '(^|,)[[:space:]]*(lis department)[[:space:]]*(,|$)' 
 ORDER BY l.title ASC
262
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'