SELECT mak.id, mak.name, mak.type, mak.user AS poster, mak.rating, mak.votes, comments.date, c2.amount, comments.user FROM mak JOIN comments ON mak.id = comments.about JOIN ( SELECT about, MAX( id ) AS latest, COUNT(*) AS amount FROM comments WHERE comment NOT LIKE '<i>%</i>%' GROUP BY about ORDER BY latest DESC ) AS c2 ON comments.id = c2.latest GROUP BY mak.id ORDER BY comments.date DESC; 

Basically this shows articles in order of when the most recent comment was, ignoring any service comment (those being anything that fits '<i>%</i>%'. However, when an article is first posted, a service comment is posted saying "Idea posted". At the moment, when the article is posted, it is not grabbed by this query. 

How can I make it so it will also show these newly created articles, with a 0 for comments, but they will still appear.

Thinking about it, what I'm basically saying is:

How do I make it ignore the "WHERE comment NOT LIKE '<i>%</i>%'" if the amount of comments is 1!

gausie