1.98ms |
connect |
0.84ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (Controller = 'business-skills') ORDER BY `Path` ASC |
0.82ms |
SELECT `SiteMenu`.* FROM `SiteMenu` WHERE (SiteMenu.SiteID = 'cs') ORDER BY `SiteMenu`.`MenuOrder` ASC, `SiteMenu`.`Private` ASC, `SiteMenu`.`Public` ASC |
0.45ms |
SELECT `SiteLayout`.* FROM `SiteLayout` WHERE (SiteLayout.SiteID = 'buyelearning') AND (SiteLayout.LayoutID = 'CatalogueImageFolder') |
0.65ms |
SELECT `CatLabels`.`Label`, `CatLabels`.`Description` FROM `CatCatalogueTrees`
INNER JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueTrees.LabelID WHERE (CatCatalogueTrees.CatalogueTreeID = '11000') AND (CatLabels.LabelSiteID IN ('ALL','buyelearning')) AND (CatCatalogueTrees.ParentID = '11013') ORDER BY CatLabels.LabelSiteID = 'ALL' LIMIT 1 |
0.46ms |
SELECT `CatLabels`.`Label`, `CatLabels`.`Description` FROM `CatCatalogueTrees`
INNER JOIN `CatLabels` ON CatLabels.LabelID = CatCatalogueTrees.LabelID WHERE (CatCatalogueTrees.CatalogueTreeID = '11026') AND (CatLabels.LabelSiteID IN ('ALL','buyelearning')) AND (CatCatalogueTrees.ParentID = '11013') ORDER BY CatLabels.LabelSiteID = 'ALL' LIMIT 1 |
2.91ms |
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 = '11026') 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.97ms |
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 = '11026') ORDER BY `CatCatalogueCategories`.`InnerOrder` ASC |
1.16ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10774') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
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 = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'IA') AND (CourseType = 'IA10') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
3.07ms |
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 = '10086') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.74ms |
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.57ms |
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.78ms |
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.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.75ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
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.57ms |
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.53ms |
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.61ms |
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.59ms |
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.64ms |
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.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
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.64ms |
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.69ms |
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.61ms |
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.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 = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.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.60ms |
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.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.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 |
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.54ms |
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.55ms |
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.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.80ms |
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.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 = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.75ms |
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.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') 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.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') 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.64ms |
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.64ms |
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.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.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.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
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.53ms |
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.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.47ms |
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.59ms |
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.91ms |
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.72ms |
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.61ms |
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.89ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.78ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10096') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
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 = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
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.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
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 = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.79ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.73ms |
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 = '') 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.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.74ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.87ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
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 = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
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 = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
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 = 'EG') AND (CourseType = 'EIL2') 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.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') 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.77ms |
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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') 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.57ms |
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 = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.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 = '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.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
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 = '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.73ms |
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 = 'EG') AND (CourseType = 'EIL2') 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 = 'EG') AND (CourseType = 'EIL2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10473') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'HE') AND (CourseType = 'HEA') 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 = '10353') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.76ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'FI') AND (CourseType = 'FIBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'FI') AND (CourseType = 'FIBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'FI') AND (CourseType = 'FIBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.76ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'FI') AND (CourseType = 'FIBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'FI') AND (CourseType = 'FIBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.19ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10204') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.75ms |
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.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EW') AND (CourseType = 'EWB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
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.59ms |
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.77ms |
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 |
1.29ms |
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 = '10553') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.66ms |
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.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 = '') 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.63ms |
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.50ms |
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.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.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.53ms |
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.66ms |
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.94ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
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.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.49ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.88ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10430') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LT') AND (CourseType = 'PD') 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 = '10764') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'LP') AND (CourseType = 'LP1') 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 = '10674') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.50ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.75ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MH') AND (CourseType = 'MCUK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.11ms |
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 = '10652') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.79ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSB') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.82ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSA') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MR') AND (CourseType = 'MMSF') 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 = '10045') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.62ms |
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.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.73ms |
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 |
1.49ms |
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 = '10308') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') 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.56ms |
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.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
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.56ms |
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.63ms |
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.60ms |
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.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.54ms |
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.61ms |
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.48ms |
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.62ms |
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.63ms |
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.54ms |
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.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.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.88ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11041') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.98ms |
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 = '11354') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV4') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'QV') AND (CourseType = 'QV5') 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 = '10787') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MO') AND (CourseType = 'MLCC') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
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 |
1.01ms |
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 = '10925') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MS') AND (CourseType = 'MS2') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.79ms |
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 = '10995') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
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 = '10530') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.56ms |
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.56ms |
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.55ms |
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.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
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.63ms |
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.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.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.52ms |
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.64ms |
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.61ms |
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.55ms |
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.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MN') AND (CourseType = 'ML1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.06ms |
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 = '10265') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.83ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'RP') AND (CourseType = 'RP04') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.47ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10146') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.97ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.44ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.47ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.51ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.64ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VADO') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.52ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.53ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.54ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'VO') AND (CourseType = 'VOTK') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.00ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10132') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.57ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = '') AND (CourseType = '') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
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.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.64ms |
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.57ms |
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 |
1.51ms |
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 = '10109') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.55ms |
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.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
5.32ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.74ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
2.48ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.76ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.86ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.83ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
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 = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.73ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.63ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.91ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.91ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.73ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.70ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.66ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.78ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.61ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.55ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'MT') AND (CourseType = 'MAG1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.16ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '10857') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.65ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ED') AND (CourseType = 'EDC1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ED') AND (CourseType = 'EDC1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.69ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ED') AND (CourseType = 'EDC1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.92ms |
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 = '10964') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'EZ') AND (CourseType = 'BP1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.09ms |
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 = '11067') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.67ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
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 = 'ME3') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'ME') AND (CourseType = 'ME4') 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 = '10327') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.60ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'CO') AND (CourseType = 'CPL1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.24ms |
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 = '10159') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.68ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WG') AND (CourseType = 'WLK1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.59ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WG') AND (CourseType = 'WLK1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WG') AND (CourseType = 'WLK1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.58ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WG') AND (CourseType = 'WLK1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.56ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'WG') AND (CourseType = 'WLK1') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
1.16ms |
SELECT `CatCategoryCourses`.*, `EkCourses`.*, `Events`.*, `Exams`.*, `URLs`.*, `ClassroomCourses`.*, CASE CatCategoryCourses.Type
WHEN "course" then EkCourses.Course_Title
WHEN "event" then Events.EventTopic
WHEN "exam" then Exams.Title
WHEN "URL" then URLs.name
WHEN "classroom" then ClassroomCourses.Course_Title
END AS `Title` FROM `CatCategoryCourses`
LEFT JOIN `EkCourses` ON EkCourses.Course_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "course"
LEFT JOIN `Events` ON Events.EventID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "event"
LEFT JOIN `Exams` ON Exams.ExamID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "exam"
LEFT JOIN `URLs` ON URLs.URL_ID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "URL"
LEFT JOIN `ClassroomCourses` ON ClassroomCourses.ClassroomCourseID = CatCategoryCourses.UnitID
AND CatCategoryCourses.Type = "classroom" WHERE (CatCategoryCourses.Type != "event"
OR (CatCategoryCourses.Type = "event"
AND `Events`.EventTopic IS NOT NULL AND `Events`.EventStatus != "Deleted")) AND (CatCategoryCourses.CatalogueCategoryID = '11510') ORDER BY `CatCategoryCourses`.`InnerOrder` ASC |
0.72ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.71ms |
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.67ms |
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.57ms |
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.62ms |
SELECT `SitePricing`.* FROM `SitePricing` WHERE (SiteID = 'cs') AND (VendorID = 'DB') AND (CourseType = 'DBS') AND (AllowEcommerceFallthrough = 1) LIMIT 1 |
0.97ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (CleanURLs.SiteID = 'cs') AND (URL LIKE 'catalogue/Business-Skills/Leadership-_-Management/%') ORDER BY `Controller` ASC, `Path` ASC |
0.74ms |
SELECT `CleanURLs`.`Controller`, `CleanURLs`.`Path`, `CleanURLs`.`URL` FROM `CleanURLs` WHERE (CleanURLs.SiteID = 'cs') AND (URL IN ('catalogue/Business-Skills')) |
0.57ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (URL = 'catalogue/Business-Skills/Leadership-_-Management') LIMIT 1 |
0.54ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueSearchResultsPrefixText') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
7.46ms |
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.63ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'BreadcrumbPrefix') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.43ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = '/CatalogHeader') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.42ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'BackButtonText') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.74ms |
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.95ms |
SELECT DISTINCT `Tags`.`Tag`, `Tags`.`TagID`, `Tags`.`TagTypeID` FROM `Tags` ORDER BY `Tag` ASC |
0.71ms |
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.67ms |
SELECT `CleanURLs`.* FROM `CleanURLs` WHERE (SiteID = 'cs') AND (URL = 'catalogue/Business-Skills/Leadership-_-Management') LIMIT 1 |
0.61ms |
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.38ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.36ms |
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.42ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.36ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
2.34ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
16.09ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
23.50ms |
SELECT `SiteText`.`TextDisplay` FROM `SiteText` WHERE (Tag = 'CatalogueTableColumnTitle') AND (SiteID = 'cs') AND (Language = 'UK') LIMIT 1 |
0.54ms |
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.48ms |
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.36ms |
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.37ms |
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.37ms |
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.35ms |
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 |