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='Bushwacker's Saloon'AND DATE(articles.endDate) >= DATE(NOW())
GROUP BY categories.id
ORDER BY count DESC