Incorrect DATETIME value: '0000-00-00 00:00:00'1525 - Incorrect DATETIME value: '0000-00-00 00:00:00'

select count(c.comment_id) as total, b.* from blogs b left join blog_comments c on (c.agent_id = b.agent_id and c.blog_id=b.blog_id) where b.agent_id = 0 and ( b.status = 'active' and b.release_date < now() and (b.expire_date > now() OR b.expire_date = '0000-00-00 00:00:00') ) group by b.blog_id order by b.blog_id DESC limit 0,5

[TEP STOP]

-----------------------------------------------------------