1.76ms |
connect |
0.50ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (Controller = 'compliance') ORDER BY `Path` ASC |
0.83ms |
SELECT `SiteMenu`.* FROM `SiteMenu` WHERE (SiteMenu.SiteID = 'cs') ORDER BY `SiteMenu`.`MenuOrder` ASC, `SiteMenu`.`Private` ASC, `SiteMenu`.`Public` ASC |
0.47ms |
SELECT `SiteLayout`.* FROM `SiteLayout` WHERE (SiteLayout.SiteID = 'buyelearning') AND (SiteLayout.LayoutID = 'CatalogueImageFolder') |
0.56ms |
SELECT `CatLabels`.`Label`, `CatLabels`.`Description` FROM `CatCatalogueTrees`
INNER JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueTrees.LabelID WHERE (CatCatalogueTrees.CatalogueTreeID = '11000') AND (CatLabels.LabelSiteID IN ('ALL','buyelearning')) AND (CatCatalogueTrees.ParentID = '11003') ORDER BY CatLabels.LabelSiteID = 'ALL' LIMIT 1 |
1.19ms |
SELECT `CatLabels`.`Label`, `CatLabels`.`Description` FROM `CatCatalogueTrees`
INNER JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueTrees.LabelID WHERE (CatCatalogueTrees.CatalogueTreeID = '10154') AND (CatLabels.LabelSiteID IN ('ALL','buyelearning')) AND (CatCatalogueTrees.ParentID = '11003') ORDER BY CatLabels.LabelSiteID = 'ALL' LIMIT 1 |
2.99ms |
SELECT `CatCatalogueTrees`.*, (SELECT COUNT(SitePricing.PriceTypeID) FROM `CatTreeCategoryLinks`
INNER JOIN `CatCatalogueCategories` ON CatTreeCategoryLinks.CatalogueCategoryID = CatCatalogueCategories.CatalogueCategoryID
INNER JOIN `CatCategoryCourses` ON CatCatalogueCategories.CatalogueCategoryID = CatCategoryCourses.CatalogueCategoryID
AND CatCategoryCourses.Type = "course"
INNER JOIN `EkCourses` ON CatCategoryCourses.UnitID = EkCourses.Course_ID
AND EkCourses.Course_Enable = 1
INNER JOIN `SitePricing` ON SitePricing.SiteID = "cs"
AND SitePricing.DisplayStatus = 1
AND EkCourses.VendorID = SitePricing.VendorID
AND EkCourses.CourseType = SitePricing.CourseType WHERE (CatCatalogueTrees.CatalogueTreeID = CatTreeCategoryLinks.CatalogueTreeID)) AS `Pricing1`, (SELECT COUNT(SitePricing.PriceTypeID) FROM `CatCatalogueTrees` AS `CatCatalogueTrees2`
INNER JOIN `CatTreeCategoryLinks` ON CatCatalogueTrees2.CatalogueTreeID = CatTreeCategoryLinks.CatalogueTreeID
INNER JOIN `CatCatalogueCategories` ON CatTreeCategoryLinks.CatalogueCategoryID = CatCatalogueCategories.CatalogueCategoryID
INNER JOIN `CatCategoryCourses` ON CatCatalogueCategories.CatalogueCategoryID = CatCategoryCourses.CatalogueCategoryID
AND CatCategoryCourses.Type = "course"
INNER JOIN `EkCourses` ON CatCategoryCourses.UnitID = EkCourses.Course_ID
AND EkCourses.Course_Enable = 1
INNER JOIN `SitePricing` ON SitePricing.SiteID = "cs"
AND SitePricing.DisplayStatus = 1
AND EkCourses.VendorID = SitePricing.VendorID
AND EkCourses.CourseType = SitePricing.CourseType WHERE (CatCatalogueTrees.CatalogueTreeID = CatCatalogueTrees2.ParentID)) AS `Pricing2`, (SELECT COUNT(SitePricing.PriceTypeID) FROM `CatCatalogueTrees` AS `CatCatalogueTrees3`
INNER JOIN `CatCatalogueTrees` AS `CatCatalogueTrees2` ON CatCatalogueTrees3.CatalogueTreeID = CatCatalogueTrees2.ParentID
INNER JOIN `CatTreeCategoryLinks` ON CatCatalogueTrees2.CatalogueTreeID = CatTreeCategoryLinks.CatalogueTreeID
INNER JOIN `CatCatalogueCategories` ON CatTreeCategoryLinks.CatalogueCategoryID = CatCatalogueCategories.CatalogueCategoryID
INNER JOIN `CatCategoryCourses` ON CatCatalogueCategories.CatalogueCategoryID = CatCategoryCourses.CatalogueCategoryID
AND CatCategoryCourses.Type = "course"
INNER JOIN `EkCourses` ON CatCategoryCourses.UnitID = EkCourses.Course_ID
AND EkCourses.Course_Enable = 1
INNER JOIN `SitePricing` ON SitePricing.SiteID = "cs"
AND SitePricing.DisplayStatus = 1
AND EkCourses.VendorID = SitePricing.VendorID
AND EkCourses.CourseType = SitePricing.CourseType WHERE (CatCatalogueTrees.CatalogueTreeID = CatCatalogueTrees3.ParentID)) AS `Pricing3`, (SELECT COUNT(SitePricing.PriceTypeID) FROM `CatCatalogueTrees` AS `CatCatalogueTrees4`
INNER JOIN `CatCatalogueTrees` AS `CatCatalogueTrees3` ON CatCatalogueTrees4.CatalogueTreeID = CatCatalogueTrees3.ParentID
INNER JOIN `CatCatalogueTrees` AS `CatCatalogueTrees2` ON CatCatalogueTrees3.CatalogueTreeID = CatCatalogueTrees2.ParentID
INNER JOIN `CatTreeCategoryLinks` ON CatCatalogueTrees2.CatalogueTreeID = CatTreeCategoryLinks.CatalogueTreeID
INNER JOIN `CatCatalogueCategories` ON CatTreeCategoryLinks.CatalogueCategoryID = CatCatalogueCategories.CatalogueCategoryID
INNER JOIN `CatCategoryCourses` ON CatCatalogueCategories.CatalogueCategoryID = CatCategoryCourses.CatalogueCategoryID
AND CatCategoryCourses.Type = "course"
INNER JOIN `EkCourses` ON CatCategoryCourses.UnitID = EkCourses.Course_ID
AND EkCourses.Course_Enable = 1
INNER JOIN `SitePricing` ON SitePricing.SiteID = "cs"
AND SitePricing.DisplayStatus = 1
AND EkCourses.VendorID = SitePricing.VendorID
AND EkCourses.CourseType = SitePricing.CourseType WHERE (CatCatalogueTrees.CatalogueTreeID = CatCatalogueTrees4.ParentID)) AS `Pricing4`, `CatLabels`.* FROM `CatCatalogueTrees`
INNER JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueTrees.LabelID AND CatLabels.LabelSiteID = (SELECT `LabelSite`.`LabelSiteID` FROM `CatLabels` AS `LabelSite` WHERE (LabelSite.LabelID = CatLabels.LabelID) AND (LabelSite.LabelSiteID IN ("ALL", "buyelearning")) ORDER BY LabelSite.LabelSiteID = 'ALL' LIMIT 1) WHERE (CatCatalogueTrees.ParentID = '10154') AND (CatCatalogueTrees.InnerOrder > 0) AND (CatCatalogueTrees.CatalogueTreeID NOT IN ("")) OR (CatCatalogueTrees.CatalogueTreeID IN ("")) AND (CatLabels.LabelSiteID IN ("ALL", "buyelearning")) GROUP BY `CatCatalogueTrees`.`CatalogueTreeID` HAVING (Pricing1 > 0 OR Pricing2 > 0 OR Pricing3 > 0 OR Pricing4 > 0) ORDER BY ABS(InnerOrder) ASC |
1.89ms |
SELECT DISTINCT `CatCatalogueCategories`.`CatalogueCategoryID`, `CatLabels`.`Label` FROM `CatCatalogueTrees`
INNER JOIN `CatTreeCategoryLinks` ON CatTreeCategoryLinks.CatalogueTreeID = CatCatalogueTrees.CatalogueTreeID
INNER JOIN `CatCatalogueCategories` ON CatCatalogueCategories.CatalogueCategoryID = CatTreeCategoryLinks.CatalogueCategoryID
LEFT JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueCategories.LabelID
AND CatLabels.LabelSiteID = "buyelearning" WHERE (CatCatalogueTrees.CatalogueTreeID = '10154') ORDER BY `CatCatalogueCategories`.`InnerOrder` ASC |
1.19ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10773') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA30') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.86ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10571') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.04ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10782') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.93ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10042') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.45ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MA') AND (CourseType = 'M1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.48ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10113') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.87ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11351') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.97ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11030') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.74ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10751') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WO') AND (CourseType = 'WO1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WO') AND (CourseType = 'WO1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WO') AND (CourseType = 'WO1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.83ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10580') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10378') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'TB') AND (CourseType = 'TBS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.16ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10951') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'OT') AND (CourseType = 'OUT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.03ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10303') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.87ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10678') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.78ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10154') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
1.47ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10526') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.05ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.89ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10923') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.02ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10263') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.86ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11003') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.17ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10129') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.30ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10057') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.20ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11504') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.94ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10322') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.39ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10208') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.89ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10557') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.82ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10855') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ED') AND (CourseType = 'EDC2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.10ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10121') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME7') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'GDPM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'GDPB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'GDPC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'GDPF') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'GDPM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'GDPP') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.88ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10100') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'GDPR') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.37ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10125') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.45ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.45ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11200') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'ISM') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.45ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IF') AND (CourseType = 'IST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.73ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (CleanURLs.SiteID = 'cs') AND (URL LIKE 'catalogue/Compliance/Financial-_-Data-Compliance/%') ORDER BY `Controller` ASC, `Path` ASC |
0.55ms |
SELECT `CleanURLs`.`Controller`, `CleanURLs`.`Path`, `CleanURLs`.`URL` FROM `CleanURLs` WHERE (CleanURLs.SiteID = 'cs') AND (URL IN ('catalogue/Compliance')) |
0.49ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (URL = 'catalogue/Compliance/Financial-_-Data-Compliance') LIMIT 1 |
0.47ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueSearchResultsPrefixText') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
4.81ms |
SELECT `SiteMenu`.`id`, `SiteMenuLanguage`.`Label` AS `LanguageLabel`, `SiteMenu`.`Label`, COALESCE(SiteMenuLanguage.Language, "UK") AS `Language`, `SiteMenu`.`Path`, `SiteMenu`.`SiteID`, `SiteMenu`.`MenuOrder`, `SiteMenu`.`Private`, `SiteMenu`.`Public`, `SiteText`.* FROM `SiteMenu`
LEFT JOIN `SiteMenuLanguage` ON SiteMenu.Path = SiteMenuLanguage.Path AND SiteMenuLanguage.Language = "UK"
LEFT JOIN `SiteText` ON SiteMenu.Path = CONCAT("#", SiteText.Tag) WHERE (SiteMenu.SiteID = "cs") AND (SiteMenu.SiteID = 'cs') AND (SiteMenu.Path = 'catalogue') ORDER BY `SiteMenu`.`MenuOrder` ASC |
0.44ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'BreadcrumbPrefix') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.45ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = '/CatalogHeader') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.29ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'BackButtonText') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.59ms |
SELECT `HasPermission`.* FROM `SiteTags` AS `HasPermission` WHERE (HasPermission.SiteID IN ('ALL', 'cs')) AND (HasPermission.CanView > 0 AND CanView <= 1) AND (NOT EXISTS (SELECT `NoPermission`.`CanView` FROM `SiteTags` AS `NoPermission` WHERE (NoPermission.SiteID = 'cs') AND (NoPermission.TagTypeID = HasPermission.TagTypeID) AND (NoPermission.CanView = 0))) |
1.45ms |
SELECT DISTINCT `Tags`.`Tag`, `Tags`.`TagID`, `Tags`.`TagTypeID` FROM `Tags` ORDER BY `Tag` ASC |
0.50ms |
SELECT `TagTypes`.* FROM `TagTypes` WHERE (TagTypeID IN ('9', '2', '14', '28', '18', '27', '25', '26', '22', '24', '1', '23', '17', '4', '10', '16', '29', '11', '3', '12', '13', '15', '21', '19', '8')) ORDER BY `TagType` ASC |
0.52ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (URL = 'catalogue/Compliance/Financial-_-Data-Compliance') LIMIT 1 |
0.44ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.33ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.44ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.31ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.32ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.32ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.31ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.29ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.48ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.33ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.30ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.29ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.27ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.27ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.31ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.32ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.29ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.37ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.32ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.47ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.35ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.31ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |