SELECT DISTINCT
    B.MEET,
    A.ID COURSEOUTLINEID,
    A.REFFERENCE_NAME COURSEOUTLINE,
    B.WEEK,
    '' STATUS
FROM
    CLO_MATERIAL_TEACHING A
    JOIN CLO_TEACHING_PLANS B ON ( CLO_LEARNING_PLAN_ID = B.ID )
WHERE
    SUBJECTID = '$subjectID'
    AND SCHOOLYEAR = '$schoolYear'
    AND SEMESTER = '$semester'
    AND A.ACTIVE_STATUS = '1'
    AND B.ACTIVE_STATUS = '1'
    AND B.APPROVAL_STATUS = 'A'
ORDER BY
    B.WEEK,
    B.MEET,
    A.ID;
SELECT
    LECTURESID,
    CLO_MATERIAL_TEACHING_ID COURSEOUTLINEID,
    COURSEID
FROM
    LECTURES_CLO_MATERIAL_TEACHING
    JOIN LECTURES USING ( LECTURESID )
WHERE
    LECTURES.COURSEID = '$courseId'
    AND CLO_MATERIAL_TEACHING_ID = '$courseOutlineId'