`SELECT `chapter_id`, `chapter_title`, `actual_content_type`, `area_name`, `status`
FROM ((
      SELECT `css`.`chapter_id`, `css`.`chapter_title`, `a`.`name` AS
      `area_name`, `css`.`content_status` AS `status`, `css`.`actual_content_type`
      FROM `dm_content_search_summary` `css`
      INNER JOIN `curriculum` `cu` ON css.curriculum_id=cu.id
      INNER JOIN `year` `y` ON css.year_id=y.id
      INNER JOIN `area` `a` ON y.area_id=a.id
      INNER JOIN `country` `cou` ON a.country_id=cou.id
    )
      UNION ALL (
       SELECT `cpx`.`category_id` AS `chapter_id`, `cat`.`name` AS
            `chapter_title`, `a`.`name` AS `area_name`, `pa`.`status` AS
            `status`, 'PROVE_IT' AS actual_content_type
       FROM `qbnk_published_assessment` `pa`
       INNER JOIN `qbnk_assessment` `ass` ON pa.assessment_id=ass.id
       INNER JOIN `qbnk_assessment_question_xref` `aq` ON
                ass.id=aq.assessment_id
       INNER JOIN `qbnk_question` `q` ON aq.question_id=q.id
       INNER JOIN `qbnk_answer` `an` ON q.id=an.question_id
       INNER JOIN `qbnk_category_published_assessment_xref` `cpx` ON
            pa.id=cpx.published_assessment_id
       INNER JOIN `category` `cat` ON cpx.category_id=cat.id
       INNER JOIN `course` `co` ON cat.course_id=co.id
       INNER JOIN `curriculum` `cu` ON co.curriculum_id=cu.id
       INNER JOIN `year` `y` ON cu.year_id = y.id
       INNER JOIN `area` `a` ON y.area_id=a.id
       INNER JOIN `country` `cou` ON a.country_id=cou.id
         GROUP BY `pa`.`assessment_id`
  )
) `0` ORDER BY `chapter_title``