|
Internet Biblical Seminary Discipleship Training to Reach the World for Christ |
View Study Program
Type
Language
Abridged Course Study - Personal Development OnlyPrint
Last Updated 2015-10-08
| Description | Each course in this study program is based off of BEE World's full version of the same course. These courses have less reading material and fewer questions to answer, but still cover the main objectives of the course. |
|---|---|
| Language | English |
| Required Courses | 0 |
| Electives | 0 |
| Student Notes | Other courses will be added to this program as they become available. Upcoming courses are: Christian Life, Abridged Edition Church Dynamics, Abridged Edition One to One, Abridged Edition |
| 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=28) 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 = 28 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=28 AND sp_status = 'PUBLISHED' ORDER BY sp_name157 |