[EventCalendar] showing only some of event-types

[cool2sv]

Nice, can you help me with a sql query I'm trying to generate for displaying
just events and posts and not the event posts and all the posts in calendar.

I've tryed to hack the ec3 default query:

// We are interested in normal posts, as well as events.
    $sql="( $sql ) UNION
     ( SELECT DISTINCT
         id,
         post_title,
         post_date AS start_date,
         post_date AS end_date,
         0 AS allday,
         0 AS is_event
       FROM $wpdb->posts
       WHERE post_status='publish'
         AND post_date>='$begin_date'
         AND post_date<'$end_date'
         AND post_date<NOW()
     )";

But couldn't get a proper result! I'm stucked!

-- 
ID: c00l2sv
NAME: stanislav sushkov
LOCATION: romania (currently)
OCCUPATION: student
STATUS: single
PHONE NR.: +4075655963
E-MAIL: cool2sv at gmail.com
WEB: http://e-stas.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20070531/2e917b5c/attachment.htm