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 location ON location.id=articles.venueID INNER JOIN users_searchCriteria as area ON area.userID=location.id INNER JOIN users as venue ON venue.id=articles.venueID WHERE articles.active='1' AND articles.cityID='1'AND calendar.startTime>='2010-03-21' AND area.value='Bellevue' AND venue.name='DJ's Dugout Bellevue' AND calendar.startTime<'2010-03-22'