Bookmark and Share

Master of Arts in International Relations

Events

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

Past Events: 2008

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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-1-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-2-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-2-29' 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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-3-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-4-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-4-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-5-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-5-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-6-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-7-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-8-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-9-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-10-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-11-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-11-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=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2008-12-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2008-12-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

No past events for this year. Please view previous years' events by clicking the links above.