Chapter List

SELECT * FROM chapters as chap JOIN student_syllabus as ss ON ss.chapter_id = chap.chapterid WHERE ss.student_id ='' AND ss.student_id !='0' AND ss.subject_id = '415' and chap.country = 'IN' ORDER BY ss.chapternumber