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>='2009-11-21' AND venue.name='McKenna's' AND calendar.startTime<'2009-11-22'