Mine

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