select ct_event.id as ct_event_id,
ct_event.id as ct_promoter_1,
ct_event.id as condensed_row,
ct_event.id as condensed_row_new,
ct_event.name as event_name,
ct_event.name_cp as event_name_cp,
ct_event.flyer__media_info_id,
ct_event.short_headline,
ct_event.short_headline2,
ct_event.publish_points,
ct_event.publish_status as publish_status_dd,
ct_event.description as event_description,
ct_event.description_reseller,
ct_event.start_date,
ct_event.start_time,
ct_event.mod_time as event_mod_time,
ct_event.music_crowd,
ct_event.dress_code,
ct_event.age,
ct_event.menu,
ct_event.buy_url,
ct_event.ct_campaign_id,
ct_promoter.id as ct_promoter_id,
ct_promoter.id as ct_promoter_id,
venue.id as venue_id,
venue.id as venue_thumb,
venue.name as venue_name,
venue.name_modifier as venue_name_modifier,
venue.name as venue_name_edit_event,
venue.address1,
venue.city,
venue.state,
venue.zip,
venue.mod_time as venue_mod_time,
market.id as market_id,
market.name as market_name
from ct_event
LEFT JOIN ct_promoter on ct_event.ct_promoter_id = ct_promoter.id and ct_promoter.active = 1
LEFT JOIN venue on ct_event.venue_id = venue.id and venue.active = 1
LEFT JOIN market on ct_event.market_id = market.id and market.active = 1
where ct_event.active = 1 and ct_event.start_date = '12/31/2008'
and (
ct_event.publish_status = 'network'
)
/* begin appended where clause */ AND ct_event.id =
ERROR: syntax error at end of input at character 1453
/home/joonbug1/public_html/skyphp/lib/class/class.aql.php
Line: 466