SELECT articles.*,authors.name as author,COUNT(articles.category_id) AS num_arcticles_in_cat
FROM articles
LEFT JOIN authors ON articles.author_id=authors.id
LEFT JOIN categories ON articles.category_id=categories.id
WHERE 1 AND articles.category_id='33' GROUP BY articles.id ORDER BY articles.id