I have the following SQL statement here. Problem is in the comment table there is no data in there. There is a screenshot for the result. If there is no comments it should just have zero in the column instead of showing no records. Yes there is records in the database.
IFNULL(COUNT(comments.fk_idea_id), 0) as cnt
FROM ideas INNER JOIN idea_users ON ideas.fk_user_id = idea_users.user_id
INNER JOIN comments ON ideas.idea_id = comments.fk_idea_id group by ideas.idea_id