Bookmark and Share

The Globalization LLC

News

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

News : 2014

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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-12-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-11-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-10-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-9-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-8-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-7-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-6-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-5-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-4-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-3-1' AND i.post_start_date <= '2014-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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-2-1' AND i.post_start_date <= '2014-2-28' 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=220 AND i.post_start_date <= CURDATE() AND i.approved="yes" AND i.post_start_date >= '2014-1-1' AND i.post_start_date <= '2014-1-31' GROUP BY i.ID ORDER BY post_start_date DESC

No postings for 2014.