|
Internet Biblical Seminary Discipleship Training to Reach the World for Christ |
View Study Program
Type
Language
Level 1: Practical Ministry - Personal Development OnlyPrint
Last Updated 2013-08-08
| Description | 1st Level program for BEE World students |
|---|---|
| Language | English |
| Required Courses | 7 |
| Electives | 1 |
| Student Notes | Recommended sequence of courses: One to One Romans and Galatians, Second Edition Studying the Bible Colossians The Christian Life Marriage: Where God Builds Two Hearts a Home Christian Family Becoming a Facilitator (Essential Skills) Equip Notebook 1 - 6 (Elective) (*) 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=15) 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 = 15 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=15 AND sp_status = 'PUBLISHED' ORDER BY sp_name157 |