SELECT mtbl_Instructor_Curriculum.CoursePhoto,mtbl_Instructor_Curriculum.Description,mtbl_Instructor_coursemaster.Sno,mtblInstructorcategorymaster.categoryid,mtblInstructorcategorymaster.for1,mtbl_Instructor_coursemaster.cancelCount,mtbl_Instructor_coursemaster.confirmCount, mtbl_Instructor_coursemaster.CourseCode, mtbl_Instructor_coursemaster.Coursetype, mtbl_Instructor_coursemaster.StartDate, mtbl_Instructor_coursemaster.sno, mtbl_Instructor_coursemaster.EndDate, mtblInstructorcategorymaster.CategoryName, mtbl_Instructor_Curriculum.CourseName, mtbl_Instructor_Curriculum.Sno AS Curriculumid, mtbl_Instructor_coursemaster.Status,case when mtbl_Instructor_coursemaster.Status=1 then 'Active' else 'Inactive' end status1 ,Courseposition FROM mtbl_Instructor_coursemaster INNER JOIN mtblInstructorcategorymaster ON mtbl_Instructor_coursemaster.CategoryId = mtblInstructorcategorymaster.categoryid INNER JOIN mtbl_Instructor_Curriculum ON mtbl_Instructor_coursemaster.CurriculumId = mtbl_Instructor_Curriculum.sno where [coursetype] = 'ISF' and mtbl_Instructor_Curriculum.Subjectid in (select distinct Subjectid from mtbl_TeacherSubject where TeacherId=186 ) and mtbl_Instructor_coursemaster.CourseCode in (select distinct CourseCode from mtbl_Instructor_CourseTeacher where TeacherId=186 and CourseCode='INS083') ORDER BY mtbl_Instructor_Curriculum.coursename

SELECT mtbl_Instructor_Curriculum.CoursePhoto, mtbl_Instructor_Curriculum.Description, mtbl_Instructor_coursemaster.Sno, mtblInstructorcategorymaster.categoryid, mtblInstructorcategorymaster.for1, mtbl_Instructor_coursemaster.cancelCount, mtbl_Instructor_coursemaster.confirmCount, mtbl_Instructor_coursemaster.CourseCode, mtbl_Instructor_coursemaster.Coursetype, mtbl_Instructor_coursemaster.StartDate, mtbl_Instructor_coursemaster.EndDate, mtblInstructorcategorymaster.categoryname, mtbl_Instructor_Curriculum.CourseName, mtbl_Instructor_Curriculum.Sno AS Curriculumid, mtbl_Instructor_coursemaster.Status, CASE WHEN mtbl_Instructor_coursemaster.Status = 1 THEN 'Active' ELSE 'Inactive' END AS status1, mtbl_Instructor_coursemaster.Courseposition, mtbl_coursePricing.Actualprice, mtbl_coursePricing.Discountprice, mtbl_coursePricing.Actualprice - mtbl_coursePricing.Discountprice totprice, mtbl_CurrencyInfo.CurrencyShortcode FROM mtbl_Instructor_coursemaster INNER JOIN mtblInstructorcategorymaster ON mtbl_Instructor_coursemaster.CategoryId = mtblInstructorcategorymaster.categoryid INNER JOIN mtbl_Instructor_Curriculum ON mtbl_Instructor_coursemaster.CurriculumId = mtbl_Instructor_Curriculum.Sno INNER JOIN mtbl_coursePricing ON mtbl_Instructor_coursemaster.Sno = mtbl_coursePricing.CourseId AND mtbl_Instructor_coursemaster.CourseCode = mtbl_coursePricing.CourseCode INNER JOIN mtbl_CurrencyInfo ON mtbl_coursePricing.Currencyid = mtbl_CurrencyInfo.Sno WHERE (mtbl_Instructor_coursemaster.Coursetype = 'ISF') AND (mtbl_Instructor_Curriculum.Subjectid IN (SELECT DISTINCT Subjectid FROM mtbl_TeacherSubject)) and mtbl_CurrencyInfo.sno=1 AND (mtbl_Instructor_coursemaster.Sno IN (132)) and mtbl_Instructor_coursemaster.CourseCode='INS083' ORDER BY mtbl_Instructor_Curriculum.CourseName

SELECT mtbl_Instructor_Curriculum.CoursePhoto, mtbl_Instructor_Curriculum.Description, mtbl_Instructor_coursemaster.Sno, mtblInstructorcategorymaster.categoryid, mtblInstructorcategorymaster.for1, mtbl_Instructor_coursemaster.cancelCount, mtbl_Instructor_coursemaster.confirmCount, mtbl_Instructor_coursemaster.CourseCode, mtbl_Instructor_coursemaster.Coursetype, mtbl_Instructor_coursemaster.StartDate, mtbl_Instructor_coursemaster.EndDate, mtblInstructorcategorymaster.categoryname, mtbl_Instructor_Curriculum.CourseName, mtbl_Instructor_Curriculum.Sno AS Curriculumid, mtbl_Instructor_coursemaster.Status, CASE WHEN mtbl_Instructor_coursemaster.Status = 1 THEN 'Active' ELSE 'Inactive' END AS status1, mtbl_Instructor_coursemaster.Courseposition, mtbl_coursePricing.Actualprice, mtbl_coursePricing.Discountprice, mtbl_coursePricing.Actualprice - mtbl_coursePricing.Discountprice totprice, mtbl_CurrencyInfo.CurrencyShortcode FROM mtbl_Instructor_coursemaster INNER JOIN mtblInstructorcategorymaster ON mtbl_Instructor_coursemaster.CategoryId = mtblInstructorcategorymaster.categoryid INNER JOIN mtbl_Instructor_Curriculum ON mtbl_Instructor_coursemaster.CurriculumId = mtbl_Instructor_Curriculum.Sno INNER JOIN mtbl_coursePricing ON mtbl_Instructor_coursemaster.Sno = mtbl_coursePricing.CourseId AND mtbl_Instructor_coursemaster.CourseCode = mtbl_coursePricing.CourseCode INNER JOIN mtbl_CurrencyInfo ON mtbl_coursePricing.Currencyid = mtbl_CurrencyInfo.Sno WHERE (mtbl_Instructor_coursemaster.Coursetype = 'ISF') AND (mtbl_Instructor_Curriculum.Subjectid IN (SELECT DISTINCT Subjectid FROM mtbl_TeacherSubject)) and mtbl_CurrencyInfo.sno=1 AND (mtbl_Instructor_coursemaster.Sno IN (132)) and mtbl_Instructor_coursemaster.CourseCode='INS083' ORDER BY mtbl_Instructor_Curriculum.CourseName ;SELECT mtbl_Instructor_coursemaster.CourseCode,CONVERT(VARCHAR(11), mtbl_Instructor_coursemaster.StartDate, 106) StartDate ,CONVERT(VARCHAR(11), mtbl_Instructor_coursemaster.EndDate, 106) EndDate,mtbl_Instructor_Curriculum.CourseName, dbo.FindTeacherbyCoursecode(mtbl_Instructor_coursemaster.CourseCode) teachername,mtbl_coursePricing.Actualprice, mtbl_CurrencyInfo.CurrencyShortcode,dbo.FindLessonbyCoursecode(mtbl_Instructor_coursemaster.CourseCode) lessontime FROM mtbl_Instructor_coursemaster INNER JOIN mtbl_Instructor_Curriculum ON mtbl_Instructor_coursemaster.CurriculumId = mtbl_Instructor_Curriculum.Sno INNER JOIN mtbl_coursePricing ON mtbl_Instructor_coursemaster.CourseCode = mtbl_coursePricing.CourseCode INNER JOIN mtbl_CurrencyInfo ON mtbl_coursePricing.Currencyid = mtbl_CurrencyInfo.Sno where mtbl_Instructor_coursemaster.CourseCode='INS083' and mtbl_CurrencyInfo.sno=1 The Sweetness of Emaan
165,931 Lessons Delivered
3 Simple Steps - Secure Checkout
List of Orders Code Price Less Discount Total
The Sweetness of Emaan INS083 Free Free Free
MY CART
 My CART
Course Date/Time Subtotal
The Sweetness of Emaan
Shaykh Assim Al-Hakeem
INS083
Start/End Date
18 May 2014-18 May 2014

Day/Time
Sun 7:15PM - 8:45PM
£ 0.00
  Subtotal £ 0.00
  Discount £ 0.00
  Grand Total £ 0.00
  Instructor Lessons Start/End Date Day/Time Price
The Sweetness of Emaan
learn more
Shaykh Assim Al-Hakeem?
Profile
Shaykh Assim Al-Hakeem
Shaykh Assim Al-Hakeem is one of the prominent propagators of Islam in English in Saudi Arabia. He is a Saudi national, born on 23 Nov,1962 and residi...

1 Sun, 18 May 2014 - Sun, 18 May 2014 Sun, 8:15 PM - 9:45 PM Free
loading
Please wait...
0
DAYS
0
HOURS
0
MINUTES
0
SECONDS
PERSONAL DETAILS
( No Account? Click here)
 REVIEW YOUR ORDER
Course Qty Subtotal
The Sweetness of Emaan 1   £ 0.00 
  Subtotal £ 0.00  
  Discount £ 0.00  
Donation
Grand Total £ 0.00  
We accept all major cards