An Error Was Encountered
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION SELECT p.`publication_date` as fecha, c.`id` as contentId, c.*, sc.`titl' at line 1
SELECT COUNT(*) as rows FROM ( SELECT a.`publication_date` as fecha, c.`id` as contentId, c.*, sc.`title` as section FROM `tags` t, `rel_content_tag` r, contents c left join `rel_section_content` rs ON rs.`content_id` = c.`id` left join `sections` sc ON rs.`section_id` = sc.`id` inner join `articles` a ON a.`id` = c.`item_id` and c.`item_type`=1 WHERE c.`active` IS NOT NULL AND t.`id` = r.`tag_id` and c.id = r.`content_id` and t.`id` = UNION SELECT p.`publication_date` as fecha, c.`id` as contentId, c.*, sc.`title` as section FROM `tags` t, `rel_content_tag` r, contents c left join `rel_section_content` rs ON rs.`content_id` = c.`id` left join `sections` sc ON rs.`section_id` = sc.`id` inner join `posts` p ON p.`id` = c.`item_id` and c.`item_type`=6 WHERE c.`active` IS NOT NULL AND t.`id` = r.`tag_id` and c.id = r.`content_id` and t.`id` = UNION SELECT c.`creation_date` as fecha, c.`id` as contentId, c.*, sc.`title` as section FROM `tags` t, `rel_content_tag` r, contents c left join `rel_section_content` rs ON rs.`content_id` = c.`id` left join `sections` sc ON rs.`section_id` = sc.`id` inner join `videos` v ON v.`id` = c.`item_id` and c.`item_type`=2 WHERE c.`active` IS NOT NULL AND t.`id` = r.`tag_id` and c.id = r.`content_id` and t.`id` = UNION SELECT c.`creation_date` as fecha, c.`id` as contentId, c.*, sc.`title` as section FROM `tags` t, `rel_content_tag` r, contents c left join `rel_section_content` rs ON rs.`content_id` = c.`id` left join `sections` sc ON rs.`section_id` = sc.`id` inner join `links` l ON l.`id` = c.`item_id` and c.`item_type`=5 WHERE c.`active` IS NOT NULL AND t.`id` = r.`tag_id` and c.id = r.`content_id` and t.`id` = )a