Internet Biblical Seminary Discipleship Training to Reach the World for Christ |
Description | 2nd Level program for BEE World students |
---|---|
Language | English |
Required Courses | 7 |
Electives | 1 |
Student Notes | Recommended sequence of courses: Church Dynamics Preaching / Teaching (*) Life of Christ, Volume 1 Life of Christ, Volume 2 Missions (*) Doctrine 1 Doctrine 2 How to Set Up a CBTC (*) (Essential Skill) (*) These courses are not yet available on IBS. |
Courses | fail -- SELECT
course_id,
course_name,
course_code,
course_tlc,
tbl_language.language_tlc,
spc_mandatory,
group_concat(concat('$study_type_',tbl_studytype.stype_abbrev)) as stype_name,
(select count(*) FROM tbl_pb_course_formats pcf, tbl_ac_sales_materials asm
WHERE pcf.cf_course_id = course_id AND asm.cf_id = pcf.cf_id AND asm.ac_mcid = 1 and sp_id=16) num_sales_items
FROM
tbl_studyplan_courses,
tbl_studyplan_class_types,
tbl_language as tbl_langST,
tbl_studytype,
tbl_courses,
tbl_language
WHERE
spc_spid = 16 and
spc_crsid = course_id and
tbl_language.language_id = course_langid and
tbl_studyplan_class_types.spct_crsid = tbl_studyplan_courses.spc_crsid and
tbl_studyplan_class_types.spct_spid = tbl_studyplan_courses.spc_spid and
tbl_studytype.stype_abbrev = tbl_studyplan_class_types.spct_stype_abbrev and
tbl_langST.language_tlc = 'en' and
tbl_studytype.stype_langid = tbl_langST.language_id
GROUP BY course_id
ORDER BY
spc_mandatory desc, course_name asc SELECT tbl_studyplans.*, tbl_language.language_iname FROM tbl_studyplans, tbl_language WHERE tbl_language.language_id = sp_lang_id AND sp_mcid = 1 and sp_id=16 AND sp_status = 'PUBLISHED' ORDER BY sp_name157 |