There is a problem with your SQL:
SELECT COUNT(articles.id) AS count FROM articles INNER JOIN calendar ON calendar.articleID=articles.id INNER JOIN users as venue ON venue.id=articles.venueID WHERE articles.active='1' AND articles.cityID='1'AND calendar.startTime>='2010-03-22' AND venue.name='DJ's Dugout Bellevue' AND calendar.startTime<'2010-03-23'