upcoming_events.sql

SELECT node.nid AS nid, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node_data_field_date.field_date_rrule AS node_data_field_date_field_date_rrule, node_data_field_date.delta AS node_data_field_date_delta, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format 

FROM node node  LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid 

LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid 

WHERE ((node.type in ('event')) AND 
(node.status <> 0)) AND 

((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(3600)), '%Y-%m') <= '2010-09' AND
 DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(3600)), '%Y-%m') >= '2010-09')) 

ORDER BY node_data_field_date_field_date_value ASC