ImageImageImage
John V. Pavlik
Title: Department Chair, Journalism and Media Studies
Title2: Professor
Department: Journalism and Media Studies
John V. Pavlik
Contact Info
Office: SDW-105
Phone: 732-932-7500 ext. 8026
Fax: 732-932-1523
Email: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
Office Hours: W 12-1pm and by appt.
Web: comminfo.rutgers.edu/jri/John/
Curriculum Vitae
 
Bio
Bio Text: "

John V. Pavlik is professor and chair of the Department of Journalism and Media Studies at the School of Communication and Information, Rutgers, the State University of New Jersey. He is also director of the Journalism Resources Institute at Rutgers. As well, Pavlik is faculty associate at the Columbia Institute for Tele-Information (CITI). He is chair of the editorial board for Television Quarterly, the journal of the National Academy of Television Arts and Sciences. He is the former executive director of The Center for New Media at the Columbia University Graduate School of Journalism, where he was also a professor. He is a former senior fellow of the San Diego Supercomputer Center. Previously, he served as the founding director of the School of Communication at San Diego State University. He is the former associate director for Research and Technology Studies at The Freedom Forum Media Studies Center at Columbia University. Pavlik has written many publications on the impact of new technology on journalism, media and society. His most recent book is Media in the Digital Age, published in 2008 by Columbia University Press.  Converging Media, co-authored with Shawn McIntosh, was published in 2004 by Allyn & Bacon. His other books include Journalism and New Media, published in 2001 by Columbia University Press, and New Media Technology: Cultural and Commercial Perspectives, 2nd edition published in 1998 by Allyn & Bacon. Pavlik has also authored more than a dozen computer software packages for education in journalism and communication. Pavlik's Ph.D. and M.A. in mass communication are from the University of Minnesota. He is a 1978 graduate of the School of Journalism and Mass Communication at the University of Wisconsin at Madison

"
Fields of Study: New media, journalism and society.
Research Interests: New media, journalism and society.
Faculty/Staff Login Copyright © 2010 Rutgers, the State University of New Jersey. All Rights Reserved.
124 queries executed
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/jpavlik/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 < '1265735007' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265755707' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_session
 WHERE session_id = '7982bd8e806d167cf469408fdfa3bb7c'
7
SELECT session_id
 FROM jos_session
 WHERE session_id = 'beab99a73dd6b37caad29e426eda264f'
8
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'beab99a73dd6b37caad29e426eda264f','1265756607','','0','1' )
9
SELECT *
 FROM jos_menu
 WHERE id = 61
10
SELECT * FROM jos_comprofiler c, jos_users u WHERE c.id=u.id AND c.id=150
11
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
12
SELECT gid FROM jos_users WHERE id = 150
13
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
14
SELECT * FROM jos_comprofiler_tabs t
 WHERE t.enabled=1
 ORDER BY t.position, t.ordering
15
SELECT * FROM jos_comprofiler_plug_cbvitae WHERE userid='150'
16
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 2 
 ORDER BY f.ordering
17
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 11 
 ORDER BY f.ordering
18
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 31 
 ORDER BY f.ordering
19
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 28 
 ORDER BY f.ordering
20
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 25 
 ORDER BY f.ordering
21
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 30 
 ORDER BY f.ordering
22
SELECT * FROM jos_comprofiler_views WHERE viewer_id = 0 AND profile_id = 150 AND lastip = '38.107.191.84'
23
INSERT INTO jos_comprofiler_views ( viewer_id, profile_id, lastip, lastview, viewscount )
 VALUES ( 0, 150, '38.107.191.84', NOW(), 1 )
24
UPDATE jos_comprofiler SET hits=(hits+1) WHERE id=150
25
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'
26
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
27
SELECT cb.* 
 FROM jos_comprofiler cb 
 WHERE cb.user_id = '150'
28
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'
29
SELECT ctx.id, ctx.context, ctx.selected, ctx.quicklink, ctx.quicklinkonly 
 FROM jos_scilssearch ctx 
 ORDER BY ordering
30
SELECT m.* FROM jos_menu AS m WHERE menutype='General Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
31
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
32
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=50'
33
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
34
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%')
35
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
36
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=50&option=com_content&task=view'
37
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=50&option=com_content&task=view'
38
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
39
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%')
40
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
41
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=55&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=601'
43
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%')
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 = 601
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
45
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2604&id=601&option=com_content&task=view'
46
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2632&id=39&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=243'
48
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%')
49
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=54&id=243&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=12'
51
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%')
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 = 12
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
53
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2608&id=12&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=13'
55
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%')
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 = 13
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
57
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2609&id=13&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=14'
59
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%')
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 = 14
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
61
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2610&id=14&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=704'
63
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%')
64
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
65
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2611&id=704&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=16'
67
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%')
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 = 16
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
69
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2612&id=16&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=992'
71
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%')
72
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2768&id=992&option=com_content&task=view'
73
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=128'
74
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%')
75
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
76
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2614&id=128&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=600'
78
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%')
79
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=78&id=600&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=581'
81
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%')
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 = 581
 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=581&option=com_content&task=view'
84
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=592'
85
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%')
86
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
87
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2702&id=592&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=921'
89
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%')
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 = 921
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
91
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2701&id=921&option=com_content&task=view'
92
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=187&option=com_content&task=view'
93
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=603&option=com_content&task=view'
94
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=604&option=com_content&task=view'
95
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2709&id=605&option=com_content&task=view'
96
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=625'
97
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%')
98
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 625
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2741&id=625&option=com_content&task=view'
100
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=61&id=38&option=com_content&task=view'
101
SELECT m.* FROM jos_menu AS m WHERE menutype='Departmental Navigation' AND published = 1 AND access <= 0 ORDER BY ordering
102
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=124&id=76&option=com_content&task=view'
103
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=125&id=86&option=com_content&task=view'
104
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=126&id=87&option=com_content&task=view'
105
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=127&id=135&option=com_content&task=view'
106
SELECT c.*, u.name as authorname FROM jos_comprofiler c, jos_users u WHERE u.id = c.user_id AND c.id = '150'
107
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'cv'
108
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 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND c.access <= 0
109
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 = '150' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC
110
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 = '150' 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
111
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'research'
112
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 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND c.access <= 0
113
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 = '150' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND c.access <= 0 
 ORDER BY c.created DESC
114
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 = '150' 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
115
SELECT t.* 
 FROM jos_tagvocabulary t 
 WHERE t.tagname = 'publications'
116
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 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND c.access <= 0
117
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 = '150' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 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 = '150' 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
119
SELECT c.*, u.name as authorname FROM jos_comprofiler c, jos_users u WHERE u.id = c.user_id AND c.id = '150'
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 = '27' 
 AND u.id = '150' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND NOT(c.metakey REGEXP '(^|,)[[:space:]]*(cv|research|publications)[[:space:]]*(,|$)') 
 AND c.access <= 0 
 ORDER BY c.created DESC
121
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 = '150' 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
122
SELECT c.*, u.name as authorname FROM jos_comprofiler c, jos_users u WHERE u.id = c.user_id AND c.id = '150'
123
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 = '150' 
 AND c.state = '1' 
 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-02-09 18:03:27' ) 
 AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-02-09 18:03:27' ) 
 AND c.access <= 0 
 AND DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= c.created 
 ORDER BY c.created DESC
124
SELECT sef.url 
 FROM jos_scilssef sef 
 WHERE sef.querystring = 'Itemid=2650&id=64&option=com_content&task=view'