SELECT 'Mata Pelajaran Unik (Subject)' AS type, COUNT(DISTINCT s.id) AS total FROM shieldtech_curriculum.curriculum_subjects s JOIN shieldtech_curriculum.active_curriculums ac ON s.id = ac.curriculum_subject_course_id AND ac.curriculum_type_id = 1 WHERE ac.version_year = ? AND s.is_active = 1 UNION ALL SELECT 'Kursus Unik (Course)' AS type, COUNT(DISTINCT c.id) AS total FROM shieldtech_curriculum.curriculum_courses c JOIN shieldtech_curriculum.active_curriculums ac ON c.id = ac.curriculum_subject_course_id AND ac.curriculum_type_id = 2 WHERE ac.version_year = ? AND c.is_active = 1;

SELECT 'Mata Pelajaran Unik (Subject)' AS type, COUNT(DISTINCT s.id) AS total FROM shieldtech_curriculum.curriculum_subjects s JOIN shieldtech_curriculum.active_curriculums ac ON s.id = ac.curriculum_subject_course_id AND ac.curriculum_type_id = 1 WHERE ac.version_year = ? AND s.is_active = 1 UNION ALL SELECT 'Kursus Unik (Course)' AS type, COUNT(DISTINCT c.id) AS total FROM shieldtech_curriculum.curriculum_courses c JOIN shieldtech_curriculum.active_curriculums ac ON c.id = ac.curriculum_subject_course_id AND ac.curriculum_type_id = 2 WHERE ac.version_year = ? AND c.is_active = 1;