$result_query = db_query("
SELECT node.nid
AS nid, node_data_field_event_date.field_event_date_value
AS node_data_field_event_date_field_event_date_value, node_data_field_event_date.field_event_date_value2
AS node_data_field_event_date_field_event_date_value2, node.type
AS node_type, node.vid
AS node_vid, node.title
AS node_title
FROM node node
LEFT JOIN content_type_event node_data_field_event_date
ON node.vid = node_data_field_event_date.vid
WHERE ((node.type in ('event'))
AND (node.language in ('%s'))
AND (node.status <> 0)
AND (node.promote <> 0))
AND ((DATE_FORMAT(ADDTIME(node_data_field_event_date.field_event_date_value, SEC_TO_TIME(3600)), '%Y-%m-%d') >= '2009-10-19')
OR (DATE_FORMAT(ADDTIME(node_data_field_event_date.field_event_date_value2, SEC_TO_TIME(3600)), '%Y-%m-%d') >= '2009-10-19')
OR ((DATE_FORMAT(ADDTIME(node_data_field_event_date.field_event_date_value, SEC_TO_TIME(3600)), '%Y-%m') <= '2009-10'
AND DATE_FORMAT(ADDTIME(node_data_field_event_date.field_event_date_value2, SEC_TO_TIME(3600)), '%Y-%m') >= '2009-10')))
ORDER BY node_data_field_event_date_field_event_date_value ASC", $node->language);