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 null