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=4 ) and mtbl_Instructor_coursemaster.CourseCode in (select distinct CourseCode from mtbl_Instructor_CourseTeacher where TeacherId=4 and CourseCode='INS046') 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 (64)) and mtbl_Instructor_coursemaster.CourseCode='INS046' 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 (64)) and mtbl_Instructor_coursemaster.CourseCode='INS046' 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='INS046' and mtbl_CurrencyInfo.sno=1 Sisters Only Free Online Event and Q&A: Emaan... A Paradise within You
166,018 Lessons Delivered
3 Simple Steps - Secure Checkout
List of Orders Code Price Less Discount Total
Sisters Only Free Online Event and Q&A: Emaan... A Paradise within You INS046 Free Free Free
MY CART
 My CART
Course Date/Time Subtotal
Sisters Only Free Online Event and Q&A: Emaan... A Paradise within You
Shaykha Tasneem Guddam
INS046
Start/End Date
11 Jan 2014-11 Jan 2014

Day/Time
Sat 6:30PM - 7:30PM
£ 0.00
  Subtotal £ 0.00
  Discount £ 0.00
  Grand Total £ 0.00
  Instructor Lessons Start/End Date Day/Time Price
Sisters Only Free Online Event and Q&A: Emaan... A Paradise within You
learn more
Shaykha Tasneem Guddam?
Profile
Shaykha Tasneem Guddam
Ustadha Tasneem Guddam (Head of Qaida Noorania and Quran) holds a BA in Islamic Law and has studied under various male and female scholars in Yemen. ...

1 Sat, 11 Jan 2014 - Sat, 11 Jan 2014 Sat, 6:30 PM - 7:30 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
Sisters Only Free Online Event and Q&A: Emaan... A Paradise within You 1   £ 0.00 
  Subtotal £ 0.00  
  Discount £ 0.00  
Donation
Grand Total £ 0.00  
We accept all major cards