DB Error: syntax error <BR> (<pre>      

      SELECT 
calendar_event.event_id, calendar_event.event_name, calendar_event.event_all_day, calendar_event.event_location, calendar_event.event_contact, calendar_event.event_phone, calendar_event.event_email, calendar_date.date_start, calendar_date.date_end, user.user_id, user.username, "" AS target
      FROM calendar_event, calendar_date, calendar_groups_xref, user, calendar_attendee
      WHERE calendar_event.event_id = calendar_date.event_id
      AND calendar_event.event_id = calendar_groups_xref.event_id
      AND calendar_attendee.user_id = user.user_id
      AND date_start >= '1210219200'
      AND date_start <= '1210305599'
      AND calendar_event.event_id = calendar_attendee.event_id
       
       AND calendar_event.event_availability = 'PUBLIC'  
       
      
      
      

      UNION

      SELECT 
calendar_event.event_id, calendar_event.event_name, calendar_event.event_all_day, calendar_event.event_location, calendar_event.event_contact, calendar_event.event_phone, calendar_event.event_email, calendar_date.date_start, calendar_date.date_end, user.user_id, user.username, "" AS target
      FROM calendar_event, calendar_date, calendar_groups_xref, user
      WHERE calendar_event.event_id = calendar_date.event_id
      AND calendar_event.event_id = calendar_groups_xref.event_id
      AND calendar_event.owner_id = user.user_id
      AND date_start >= '1210219200'
      AND date_start <= '1210305599'
       
       AND calendar_event.event_availability = 'PUBLIC'  
       
      
      
      
      ORDER BY </pre>)