Query <b>
	SELECT
		b.*, b.id blog_id, u.id auth_id, CONCAT(u.first_name, ' ', u.last_name) author, u.first_name author_first_name, CONCAT(u.first_name, '-', u.last_name) auth_text_id,
		COUNT(bcmt.id) comment_count
	FROM blog b,  users u
	LEFT JOIN blog_comments bcmt ON bcmt.blog_id = b.id
	WHERE b.user_id = u.id
	AND b.active = 1
	AND (b.approved IS NOT NULL AND b.approved_by IS NOT NULL)
	GROUP BY blog_id
	ORDER BY date
</b> failed with error Unknown column 'b.id' in 'on clause'