select count(*) as count from ct_event LEFT JOIN venue on ct_event.venue_id = venue.id and venue.active = 1 where ct_event.active = 1 and ct_event.publish_status = 'network' and ct_event.market_id = and ct_event.start_date = '12/31/2010' and venue.id is not nullERROR: syntax error at or near "and" at character 216

