1.44ms |
connect |
0.74ms |
SELECT `SiteSettings`.* FROM `SiteSettings` WHERE (SiteID = 'cs') LIMIT 1 |
0.55ms |
SELECT `SiteSettingsExt`.* FROM `SiteSettingsExt` WHERE (SiteID = "ALL") AND (DataKey = "LastCookieID") LIMIT 1 |
5.56ms |
UPDATE `SiteSettingsExt` SET `DataVal` = '956898' WHERE (SiteID = "ALL") AND (DataKey = "LastCookieID") AND (DataVal = "956897") |
1.21ms |
SELECT `SiteSettingsExt`.* FROM `SiteSettingsExt` WHERE (SiteID = 'cs') |
0.50ms |
SELECT `SiteSettingsExt`.* FROM `SiteSettingsExt` WHERE (SiteID = 'ALL') |
0.52ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (Controller = 'health-and-safety') ORDER BY `Path` ASC |
0.58ms |
SELECT `SiteLayout`.* FROM `SiteLayout` WHERE (SiteLayout.SiteID = 'cs') |
0.59ms |
SELECT `SiteMenu`.* FROM `SiteMenu` WHERE (SiteMenu.SiteID = 'cs') ORDER BY `SiteMenu`.`MenuOrder` ASC, `SiteMenu`.`Private` ASC, `SiteMenu`.`Public` ASC |
0.37ms |
SELECT `SiteLayout`.* FROM `SiteLayout` WHERE (SiteLayout.SiteID = 'buyelearning') AND (SiteLayout.LayoutID = 'CatalogueImageFolder') |
0.64ms |
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')) ORDER BY CatLabels.LabelSiteID = 'ALL' LIMIT 1 |
0.56ms |
SELECT `CatLabels`.`Label`, `CatLabels`.`Description` FROM `CatCatalogueTrees`
INNER JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueTrees.LabelID WHERE (CatCatalogueTrees.CatalogueTreeID = '11001') AND (CatLabels.LabelSiteID IN ('ALL','buyelearning')) ORDER BY CatLabels.LabelSiteID = 'ALL' LIMIT 1 |
9.98ms |
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 = '11001') 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 |
0.99ms |
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 = '11001') ORDER BY `CatCatalogueCategories`.`InnerOrder` ASC |
1.24ms |
DESCRIBE `CatCategoryCourses` |
9.91ms |
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 = '10112') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
1.61ms |
DESCRIBE `SitePricing` |
0.61ms |
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 = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') 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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') 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.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') 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.54ms |
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.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') 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.61ms |
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.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') 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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.40ms |
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 = '10051') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') 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.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
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.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
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 = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'HS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.81ms |
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 = '10595') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'PG') AND (CourseType = 'PGST') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
3.91ms |
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 = '10088') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.65ms |
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.54ms |
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 = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
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.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.73ms |
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 = '') 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.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.99ms |
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 = '10690') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IW') AND (CourseType = 'IWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IW') AND (CourseType = 'IWC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IW') AND (CourseType = 'IWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IW') AND (CourseType = 'IWC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IW') AND (CourseType = 'IWA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.31ms |
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 = '10771') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA30') 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.55ms |
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.50ms |
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.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') 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.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') 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.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
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 = 'IA5') 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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') 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.54ms |
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.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
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.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') 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.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA20') 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 = '10573') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.83ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DT') AND (CourseType = 'DT1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.14ms |
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 = '10792') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IN') AND (CourseType = 'IN3') 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 = '11352') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') 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 = '10060') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LE') AND (CourseType = 'LA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.90ms |
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 = '11031') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
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.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.85ms |
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 = '10163') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.62ms |
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 |
1.15ms |
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 = '10120') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') 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.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
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 = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
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 = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.45ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.45ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') 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.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.45ms |
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 = 'ME') AND (CourseType = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME5') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.77ms |
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 = '10753') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
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.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 = '10306') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
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 = '') 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.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 |
1.30ms |
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 = '') AND (CourseType = '') 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 = '10655') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MRSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.95ms |
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 = '10044') 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.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 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.77ms |
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.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 = '10377') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
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.51ms |
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.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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
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.61ms |
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.44ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.25ms |
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 = '10527') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.58ms |
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 |
1.03ms |
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.54ms |
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.58ms |
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.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
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.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
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.61ms |
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.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
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.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.81ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') 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 = '10784') 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.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.13ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
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.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.99ms |
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 = '10101') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.92ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') 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 = '10558') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.44ms |
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 = '10210') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.49ms |
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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.86ms |
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.56ms |
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.50ms |
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.48ms |
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.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.54ms |
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.56ms |
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.53ms |
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.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
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 |
1.38ms |
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 = '10131') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.51ms |
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.54ms |
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.58ms |
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 = '') 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.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.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.56ms |
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.60ms |
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.60ms |
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.52ms |
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.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.25ms |
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 = '10251') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
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.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
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.49ms |
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.56ms |
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.50ms |
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.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.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.27ms |
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.52ms |
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.48ms |
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.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 = '10252') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.08ms |
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 = '11507') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.51ms |
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.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
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.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
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.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') 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.44ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.46ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.23ms |
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 = '10325') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') 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.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.78ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') 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.59ms |
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 = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') 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.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') 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.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') 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 = '10167') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'YL') AND (CourseType = 'YORE') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'YL') AND (CourseType = 'YORE') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'YL') AND (CourseType = 'YORE') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'YL') AND (CourseType = 'YORE') 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 = '10970') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'PR') AND (CourseType = 'PARG') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.95ms |
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 = '11150') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WW') AND (CourseType = 'WW1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (CleanURLs.SiteID = 'cs') AND (URL LIKE 'catalogue/Health-_-Safety/%') ORDER BY `Controller` ASC, `Path` ASC |
0.56ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (URL = 'catalogue/Health-_-Safety') LIMIT 1 |
0.47ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueSearchResultsPrefixText') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
4.98ms |
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.59ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'BreadcrumbPrefix') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.31ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = '/CatalogHeader') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.59ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'BackButtonText') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.58ms |
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))) |
0.87ms |
SELECT DISTINCT `Tags`.`Tag`, `Tags`.`TagID`, `Tags`.`TagTypeID` FROM `Tags` ORDER BY `Tag` ASC |
0.58ms |
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.62ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (URL = 'catalogue/Health-_-Safety') LIMIT 1 |
0.53ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.40ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.40ms |
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.40ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.46ms |
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.39ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.57ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.46ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.34ms |
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.46ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.42ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.50ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.38ms |
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.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.44ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.46ms |
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.85ms |
SELECT `SiteText`.`TextDisplay`, `SiteSettings`.* FROM `SiteText`
INNER JOIN `SiteSettings` ON SiteText.SiteID = SiteSettings.TextSiteID WHERE (SiteSettings.SiteID = 'cs') AND (Language = 'UK') AND (Tag = 'CSS') |
0.64ms |
SELECT `SiteText`.`TextDisplay`, `SiteSettings`.* FROM `SiteText`
INNER JOIN `SiteSettings` ON SiteText.SiteID = SiteSettings.TextSiteID WHERE (SiteSettings.SiteID = 'cs') AND (Language = '') AND (Tag = 'HeaderJS') |
0.57ms |
SELECT `SiteText`.`TextDisplay`, `SiteSettings`.* FROM `SiteText`
INNER JOIN `SiteSettings` ON SiteText.SiteID = SiteSettings.TextSiteID WHERE (SiteSettings.SiteID = 'cs') AND (Language = 'UK') AND (Tag = 'HeaderJS') |
0.59ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'TemplateFooterHTML') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |