SELECT DATE(REPLACE(node_data_field_date.field_date_value,'T',' ')), DATE(REPLACE(node_data_field_date.field_date_value2,'T',' ')), DATE(REPLACE(node_data_field_date.field_date_value,'T',' ')) <= DATE('2007-09-11'), DATE(REPLACE(node_data_field_date.field_date_value2,'T',' ')) >= DATE('2007-09-11'), DATE('2007-09-11'), node.nid, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node.title AS node_title

FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN content_field_g_image node_data_field_g_image ON node.vid = node_data_field_g_image.vid LEFT JOIN content_field_teaser_copy node_data_field_teaser_copy ON node.vid = node_data_field_teaser_copy.vid 

WHERE (node.status = '1') AND (node.type IN ('class','event')) AND (term_node.tid IN ('6'))