Internet Biblical Seminary Discipleship Training to Reach the World for Christ |
Description | 3rd Level Program for BEE World Students |
---|---|
Language | English |
Required Courses | 8 |
Electives | 1 |
Student Notes | Recommended sequence of courses: Advanced Studies in the Old Testament, Volume 1 Advanced Studies in the Old Testament, Volume 2 Worshiping God in the Psalms Daniel (*) Advanced Studies in the New Testament The Epistle to the Hebrews True Spirituality: A Study of 1st Corinthians Revelation (*) How to Write a BEE Course (*) (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=17) 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 = 17 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=17 AND sp_status = 'PUBLISHED' ORDER BY sp_name157 |