Can't perform a UNION ALL MySQL query

[eluser]Colin Williams[/eluser]
You need to tell the DB class to not protect identifiers by supplying a third param of TRUE.

Code:

$this->db->where('UNION ALL "
        SELECT * FROM `blog` ORDER BY `id` DESC
        UNION ALL
        SELECT COUNT(*) FROM blog_comentarios, blog WHERE blog_comentarios.post_id = blog.id"', NULL, TRUE);