There is a problem with your SQL:
SELECT categories.name, COUNT(articles_category.category) as `count`, categories.id FROM categories INNER JOIN articles_category ON categories.id = articles_category.category INNER JOIN articles ON articles_category.articleID = articles.id INNER JOIN users as venue ON venue.id=articles.venueID WHERE articles.active='1' AND articles.display = '1' AND articles.cityID='1' AND venue.name='Sarie's Gentlemens Club'AND DATE(articles.endDate) >= DATE(NOW()) GROUP BY categories.id ORDER BY count DESC