I have the following query:

PHP Code:
SELECT a.article_ida.titlea.texta.picturea.topic_iddate_format(a.pub_date,' %D %M %Y') as pub_dateCOUNT(c.article_id) AS total
FROM articles a LEFT JOIN comments c ON a
.article_id c.article_id
GROUP BY a
.article_ida.titlea.texta.topic_idpub_date 
What I want to do is also show articles via a topic_id URL parameter.

So before it worked with this query:

PHP Code:
SELECT *
FROM articles
WHERE topic_id 
colname 
The first query shows the article with the comments total, the second just shows the article via the topic_id.

I want to be able to show the article via the topic_id with the correct number of comments.

Any ideas?