Bookmark and Share

Department of

Biology

News

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

News : 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=12 AND o.organizationID=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-12-1' AND i.post_start_date <= '2008-12-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-11-1' AND i.post_start_date <= '2008-11-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-10-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-9-1' AND i.post_start_date <= '2008-9-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-8-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-7-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-6-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-5-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-4-1' AND i.post_start_date <= '2008-4-30' GROUP BY i.ID ORDER BY post_start_date DESC

April 2008

Thu3Allison Casciato Awarded National Cancer Institute Summer Research Fellowship
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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-3-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-2-1' AND i.post_start_date <= '2008-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=5 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2008-1-1' AND i.post_start_date <= '2008-1-31' GROUP BY i.ID ORDER BY post_start_date DESC