error while trying to run  SELECT  *  FROM  occurrence  WHERE type = "event" AND  DATE("2010-1-01 00:00:00") < end_date  AND  start_date < DATE( DATE_ADD( "2010-1-01 00:00:00", interval 1 MONTH) )  AND  end_date > NOW()  ORDER BY  start_date ASC  <BR>