Bookmark and Share

Master of Arts in International Relations

News

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

News : 2012

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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-12-1' AND i.post_start_date <= '2012-12-31' GROUP BY i.ID ORDER BY post_start_date DESC

December 2012

Mon10Euro Financial Crisis Essay Contest
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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-11-1' AND i.post_start_date <= '2012-11-30' GROUP BY i.ID ORDER BY post_start_date DESC

November 2012

Tue27Washington, DC Staff Assistant/Legislative Correspondent
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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-10-1' AND i.post_start_date <= '2012-10-31' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-9-1' AND i.post_start_date <= '2012-9-30' GROUP BY i.ID ORDER BY post_start_date DESC

September 2012

Thu13Alumni Profile of Masashi Yamazaki
Fri7Internship with Congresswoman Susan A. Davis
Thu6Think Translantic
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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-8-1' AND i.post_start_date <= '2012-8-31' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-7-1' AND i.post_start_date <= '2012-7-31' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-6-1' AND i.post_start_date <= '2012-6-30' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-5-1' AND i.post_start_date <= '2012-5-31' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-4-1' AND i.post_start_date <= '2012-4-30' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-3-1' AND i.post_start_date <= '2012-3-31' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-2-1' AND i.post_start_date <= '2012-2-29' GROUP BY i.ID ORDER BY post_start_date DESC 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=12 AND o.organizationID=16 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2012-1-1' AND i.post_start_date <= '2012-1-31' GROUP BY i.ID ORDER BY post_start_date DESC