script for college subject,course,professor,block

//script for college subject,course,professor,block

select distinct cbas.cbas_id,college_sem_id,ccc.ccc_id,hep.pi_id,css.college_subject_schedule_id,csh.college_headers_subject_id,fgyl.yl_id,cc.cc_id,cc.cc_name,
fgyl.yl_name,fsn.subjname_shortname,cbas.block_name
from dps_registrar_db.college_block_subject_schedule cbss
inner join dps_registrar_db.college_subject_schedule css on css.college_subject_schedule_id = cbss.css_id
inner join dps_registrar_db.college_subject_headers csh on csh.college_headers_subject_id = css.csh_id
inner join dps_registrar_db.file_gradeyearlevel_2016_2017 fgyl on fgyl.yl_id = css.college_year_level
inner join dps_registrar_db.college_course cc on cc.cc_id = css.college_course_id
inner join dps_registrar_db.college_course_curriculum_2016_2017 ccc on ccc.ccc_id = css.ccc_id
inner join dps_hris_db.hris_emp_personalinfo hep on hep.pi_id = css.college_professor_id
inner join file_subject_name fsn ON fsn.subjname_id = csh.college_subject_id
inner join dps_registrar_db.college_block_active_semester cbas on cbas.cbas_id = cbss.ccb_id /* eto yung nag cococnect sa block*/
WHERE css.college_course_id = 1
AND css.college_professor_id = 9



//critiria para makuha yung student na na gradan sa every subjetc
$fields1 = array();
        $fields1[] = "stud_applicant_id = {$data['college_studentF']['sai_id']} ";
        $fields1[] = "csh_id = {$data['college_studentF']['csh_id']} ";
        $fields1[] = "dept_id = {$data['college_studentF']['department_id']} ";
        /*$fields1[] = "caq_open = {$data['college_studentF']['caq_open']} ";*/
        $fields1[] = "csm_id = {$data['college_studentF']['semester_id']} ";
        $fields1[] = "cbas_id = {$data['college_studentF']['cbas_id']} ";
        $fields1[] = "cc_id = {$data['college_studentF']['cc_id']} ";
        $fields1[] = "pi_id = {$data['college_studentF']['pi_id']} ";
        $fields1[] = "cs_id = {$data['college_studentF']['college_subject_id']} ";
        $fields1[] = "gender = '{$data['college_studentF']['ppd_gender']}' ";
        $fields1[] = "yl_id = '{$_GET['yl_id']}' ";

        $conditions = implode(" and ",$fields1);