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 Kay Cassell Title: Director, Master of Library and Information Science Program Title2: Lecturer Department: Library and Information Science Contact Info Office: CIL-311 Phone: 732-932-7500 ext. 8264 Fax: 732-932-6916 Email: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it Office Hours: Monday 2:00 - 4:00 pm; Tuesday 2:00-4:00 pm;   Fields of Study: Reference and Information Service 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 = 'directory/kcassell/index.html'
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 61 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1265745713' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265766413' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 61
7
SELECT * FROM jos_comprofiler c, jos_users u WHERE c.id=u.id AND c.id=160
8
SELECT id,folder, element, published,type,params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user'  
 ORDER BY ordering
9
SELECT gid FROM jos_users WHERE id = 160
10
SELECT g1.group_id, g1.name
 FROM jos_core_acl_aro_groups g1
 LEFT JOIN jos_core_acl_aro_groups g2 ON g2.lft <= g1.lft
 WHERE g2.group_id =24
 ORDER BY g1.name
11
SELECT * FROM jos_comprofiler_tabs t
 WHERE t.enabled=1
 ORDER BY t.position, t.ordering
12
SELECT * FROM jos_comprofiler_plug_cbvitae WHERE userid='160'
13
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 2 
 ORDER BY f.ordering
14
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 11 
 ORDER BY f.ordering
15
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 31 
 ORDER BY f.ordering
16
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 28 
 ORDER BY f.ordering
17
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 25 
 ORDER BY f.ordering
18
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 30 
 ORDER BY f.ordering
19
SELECT * FROM jos_comprofiler_views WHERE viewer_id = 0 AND profile_id = 160 AND lastip = '38.107.191.82'
20
INSERT INTO jos_comprofiler_views ( viewer_id, profile_id, lastip, lastview, viewscount )
 VALUES ( 0, 160, '38.107.191.82', NOW(), 1 )
21
UPDATE jos_comprofiler SET hits=(hits+1) WHERE id=160
22
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'
23
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 = 61 )
 ORDER BY ordering
24
SELECT cb.* 
 FROM jos_comprofiler cb 
 WHERE cb.user_id = '160'
25
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'
26
SELECT ctx.id, ctx.context, ctx.selected, ctx.quicklink, ctx.quicklinkonly 
 FROM jos_scilssearch ctx 
 ORDER BY ordering
27
SELECT m.* FROM jos_menu AS m WHERE menutype='General Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
28
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
29
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=50'
30
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
31
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%')
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 = 50
 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=50&option=com_content&task=view'
34
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=50&option=com_content&task=view'
35
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
36
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%')
37
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
38
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=55&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=601'
40
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%')
41
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
42
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=601&option=com_content&task=view'
43
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2632&id=39&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=243'
45
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%')
46
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=54&id=243&option=com_content&task=view'
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
48
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%')
49
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
50
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2608&id=12&option=com_content&task=view'
51
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
52
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%')
53
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
54
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2609&id=13&option=com_content&task=view'
55
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
56
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%')
57
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
58
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2610&id=14&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=704'
60
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%')
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 = 704
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
62
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2611&id=704&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=16'
64
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%')
65
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
66
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2612&id=16&option=com_content&task=view'
67
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=992'
68
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%')
69
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2768&id=992&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=128'
71
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%')
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 = 128
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
73
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2614&id=128&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=600'
75
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%')
76
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=78&id=600&option=com_content&task=view'
77
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=581'
78
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%')
79
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
80
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=581&option=com_content&task=view'
81
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=592'
82
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%')
83
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
84
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2702&id=592&option=com_content&task=view'
85
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=921'
86
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%')
87
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 921
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
88
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=921&option=com_content&task=view'
89
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=187&option=com_content&task=view'
90
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=603&option=com_content&task=view'
91
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=604&option=com_content&task=view'
92
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=605&option=com_content&task=view'
93
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=625'
94
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%')
95
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
96
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2741&id=625&option=com_content&task=view'
97
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=38&option=com_content&task=view'
98
SELECT m.* FROM jos_menu AS m WHERE menutype='Departmental Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
99
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=124&id=76&option=com_content&task=view'
100
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=125&id=86&option=com_content&task=view'
101
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&id=87&option=com_content&task=view'
102
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=127&id=135&option=com_content&task=view'
103
SELECT c.*, u.name as authorname FROM jos_comprofiler c, jos_users u WHERE u.id = c.user_id AND c.id = '160'
104
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'cv'
105
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '0' AND c.metakey REGEXP '(^|,)[[:space:]]*cv[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0
106
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 = '27' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*cv[[:space:]]*(,|$)' 
 AND u.id = '160' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC
107
SELECT f.pgitemtitle as title, f.pgitemfilename, f.userid, f.pgitemdate, u.name as authorname, 'file' as itemtype 
 FROM jos_comprofiler_plug_profilegallery f, jos_comprofiler cb, jos_users u 
 WHERE f.userid = '160' AND cb.user_id = f.userid AND u.id = cb.user_id 
 AND f.pgitemtags REGEXP '(^|,)[[:space:]]*cv[[:space:]]*(,|$)' 
 AND f.pgitempublished = 1 AND f.pgitemapproved = 1 
 ORDER BY f.pgitemorder ASC
108
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'research'
109
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '0' AND c.metakey REGEXP '(^|,)[[:space:]]*research[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0
110
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 = '27' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*research[[:space:]]*(,|$)' 
 AND u.id = '160' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC
111
SELECT f.pgitemtitle as title, f.pgitemfilename, f.userid, f.pgitemdate, u.name as authorname, 'file' as itemtype 
 FROM jos_comprofiler_plug_profilegallery f, jos_comprofiler cb, jos_users u 
 WHERE f.userid = '160' AND cb.user_id = f.userid AND u.id = cb.user_id 
 AND f.pgitemtags REGEXP '(^|,)[[:space:]]*research[[:space:]]*(,|$)' 
 AND f.pgitempublished = 1 AND f.pgitemapproved = 1 
 ORDER BY f.pgitemorder ASC
112
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'publications'
113
SELECT c.*, c.introtext as text 
 FROM jos_content c 
 WHERE c.catid = '0' AND c.metakey REGEXP '(^|,)[[:space:]]*publications[[:space:]]*(,|$)' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0
114
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 = '27' 
 AND c.metakey REGEXP '(^|,)[[:space:]]*publications[[:space:]]*(,|$)' 
 AND u.id = '160' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC
115
SELECT f.pgitemtitle as title, f.pgitemfilename, f.userid, f.pgitemdate, u.name as authorname, 'file' as itemtype 
 FROM jos_comprofiler_plug_profilegallery f, jos_comprofiler cb, jos_users u 
 WHERE f.userid = '160' AND cb.user_id = f.userid AND u.id = cb.user_id 
 AND f.pgitemtags REGEXP '(^|,)[[:space:]]*publications[[:space:]]*(,|$)' 
 AND f.pgitempublished = 1 AND f.pgitemapproved = 1 
 ORDER BY f.pgitemorder ASC
116
SELECT c.*, u.name as authorname FROM jos_comprofiler c, jos_users u WHERE u.id = c.user_id AND c.id = '160'
117
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 = '27' 
 AND u.id = '160' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND NOT(c.metakey REGEXP '(^|,)[[:space:]]*(cv|research|publications)[[:space:]]*(,|$)') 
 AND c.access <= 0 
 ORDER BY c.created DESC
118
SELECT f.pgitemtitle as title, f.pgitemfilename, f.userid, f.pgitemdate, u.name as authorname, 'file' as itemtype 
 FROM jos_comprofiler_plug_profilegallery f, jos_comprofiler cb, jos_users u 
 WHERE f.userid = '160' AND cb.user_id = f.userid AND u.id = cb.user_id 
 AND NOT(f.pgitemtags REGEXP '(^|,)[[:space:]]*(cv|research|publications)[[:space:]]*(,|$)') 
 AND f.pgitempublished = 1 AND f.pgitemapproved = 1 
 ORDER BY f.pgitemorder ASC
119
SELECT c.*, u.name as authorname FROM jos_comprofiler c, jos_users u WHERE u.id = c.user_id AND c.id = '160'
120
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 u.id = '160' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 21:01:53' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 21:01:53' ) 
 AND c.access <= 0 
 AND DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= c.created 
 ORDER BY c.created DESC
121
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'