Bookmark and Share

Department of

Political Science and International Relations

Events

Events from: 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 |

Past Events: 2013

SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-1-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-1-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-2-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-2-28' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

February 2013

Fri1Guest Lecture with Michael Dukakis
Wed20Conference on Restoring Civility To Civic Dialogue
SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-3-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-3-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-4-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-4-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

April 2013

Thu4Peace Corps Panel Discussion
Fri12Changemaker Summer Fellow Deadline
Thu18Undergraduate Research Conference
Fri19Get Hired After College!
Mon22Applications Now Being Accepted for Summer Internships at IPJ
Thu25Azerbaijan and the Caspian Region
Tue30IPJ Film Series: 'Reconciliation: Mandela's Miracle'
SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-5-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-5-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

May 2013

Tue7Lecture and Reception with Prince Mired Raad Zeid Al Hussein of Jordan
SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-6-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-6-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-7-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-7-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-8-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-8-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-9-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-9-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-10-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-10-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-11-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-11-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

November 2013

Mon4Looking Forward in the Middle East: Panelist Discussion
Tue19The Prospects for Peace in the Holy Land
Tue19Catharine MacKinnon: Trafficking, Prostitution and Inequality
Thu21Changemaker Faculty Exchange: The Creative Entrepreneur
SELECT i.ID, i.category, i.post_start_date, i.event_start_date, i.event_start_time, i.event_end_date, i.event_end_time, DATE_FORMAT(i.post_start_date, '%m/%e/%Y') AS post_date, DATE_FORMAT(i.event_start_date, '%m/%e/%Y') AS start_date, DATE_FORMAT(i.event_end_date, '%m/%e/%Y') AS end_date, TIME_FORMAT(i.event_start_time, '%l:%i %p') AS start_time, TIME_FORMAT(i.event_end_time, '%l:%i %p') AS end_time, i.location, i.title, i.subtitle, i.icon, i.attachment, i.message, i.message_remainder, i.web_address, i.thumbnail, i.image, i.image_alt, o.organizationID AS department FROM items i JOIN item_organizations o ON i.ID=o.itemID WHERE i.category=10 AND i.event_start_date IS NOT NULL AND o.organizationID=27 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2013-12-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2013-12-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

December 2013

Thu5Knowledge Transfer: Engineering