Untitled
unknown
pgsql
a year ago
1.3 kB
2
Indexable
Never
select ms_student_parent_relation.student_parent_relation_id, ms_student_sibling.sibling_name, ms_student_sibling.sibling_nis, ms_student_sibling.student_id, ms_student_sibling.gender, ms_student_sibling.date_of_birth, ms_student_sibling.place_of_birth, ms_student_sibling.year_level_id, null as year_level_name from ms_student_parent_relation join ms_student_sibling on ms_student_sibling.sibling_id = ms_student_parent_relation.sibling_id where ms_student_sibling.deleted_at is null and ms_student_parent_relation.deleted_at is null and ms_student_parent_relation.user_uuid_parent = $1 union select ms_student_parent_relation.student_parent_relation_id, ms_student.student_name as sibling_name, ms_student.nis as sibling_nis, ms_student.student_id, ms_student.gender, ms_student.date_of_birth, ms_student.place_of_birth, ms_student.enroll_year_level_id as year_level_id, null as year_level_name from ms_student_parent_relation join ms_student on ms_student.student_id = ms_student_parent_relation.student_id where ms_student.deleted_at is null and ms_student_parent_relation.deleted_at is null and ms_student_parent_relation.user_uuid_parent = $1