Bookmark and Share

Department of

Languages, Cultures and Literatures

Events

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

Past Events: 2010

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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-1-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-2-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-2-28' 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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-3-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-4-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-4-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

April 2010

Thu15Miguel Pérez Abad Presents Andaluces Ilustres
Tue20Latin American Jewish Film Series presents "The Year My Family Went on Vacation"
Tue20Discussion of "La Traviata" by Guiseppe Verdi
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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-5-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-5-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

May 2010

Mon3David Tomas Martinez Poetry Reading
Thu6Medieval-Renaissance Colloquium: Aztec Art of Performance Poetry
Thu6Film screening: Je vous très beau
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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-6-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-7-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-8-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-9-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-9-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

September 2010

Mon13Eid al-Fitr Celebration at Pavilion Dining
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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-10-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-10-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

October 2010

Wed20San Diego's Waterfront Through the Eyes of a Child: The Italian Community in SD
Thu28Film: 'La Traviata'
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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-11-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-11-30' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

November 2010

Mon1Film: 'La cucaracha' ('The Soldiers of Pancho Villa')
Wed3Film: 'Un long dimanche de fiançailles'
Fri5Film: 'Yin shi nan nu' ('Eat, Drink, Man, Woman')
Wed10Film: 'Il papa di Giovanna'
Mon15Film: 'Arrancame la vida' ('Tear This Heart Out')
Mon15An Evening with Julia Alvarez
Wed17Film: 'Bienvenue chez les Ch'tis'
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=17 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.event_start_date >= '2010-12-1' AND (i.event_end_date IS NULL OR i.event_end_date < CURDATE()) AND i.event_start_date <= '2010-12-31' GROUP BY i.ID ORDER BY event_start_date ASC, event_start_time ASC

December 2010

Wed1Film: 'India Song'
Fri3Film: 'Joyeux Noel'
Mon6Film: 'Entre Pancho Villa y una mujer desnuda' ('Between Pancho Villa and a Naked Woman')