sql:
SELECT
cc.id,
cc.Category_Name,
COUNT(c.id) AS TotalCourses
FROM course_categories cc
LEFT JOIN courses c ON c.Category = cc.id
WHERE cc.Active = 1
GROUP BY cc.id, cc.Category_Name
ORDER BY cc.Category_Name ASC
, executionMS: 0.003741979598999
sql:
SELECT COUNT(c.id)
FROM courses c
LEFT JOIN course_categories cc ON cc.id = c.Category
WHERE 1=1 AND (c.Status = 1 OR c.Status = '1' OR c.Status = 'Active') AND c.Category = 808, executionMS: 0.00071096420288086
sql:
SELECT
c.id,
c.Course_Title,
c.Course_Code,
c.Short_Description,
c.Course_Outcomes,
c.Course_Outline,
c.Target_Audience,
c.Price,
c.Discount,
c.TotalPrice,
c.Thumbnail,
c.Views,
c.Featured,
c.Category,
cc.Category_Name,
COUNT(a.Application_ID) AS TotalApplications
FROM courses c
LEFT JOIN course_categories cc ON cc.id = c.Category
LEFT JOIN apply a ON a.Course_Title = c.id
WHERE 1=1 AND (c.Status = 1 OR c.Status = '1' OR c.Status = 'Active') AND c.Category = 808
GROUP BY
c.id,
c.Course_Title,
c.Course_Code,
c.Short_Description,
c.Course_Outcomes,
c.Course_Outline,
c.Target_Audience,
c.Price,
c.Discount,
c.TotalPrice,
c.Thumbnail,
c.Views,
c.Featured,
c.Category,
cc.Category_Name
ORDER BY c.Featured DESC, TotalApplications DESC, c.Course_Title ASC
LIMIT 10 OFFSET 20, executionMS: 1.1616148948669
sql:
SELECT
cc.id,
cc.Category_Name,
COUNT(c.id) AS TotalCourses
FROM course_categories cc
INNER JOIN courses c ON c.Category = cc.id
WHERE cc.Active = 1
GROUP BY cc.id, cc.Category_Name
ORDER BY TotalCourses DESC, cc.Category_Name ASC
LIMIT 8
, executionMS: 0.0019481182098389
sql: SELECT COUNT(id) FROM courses, executionMS: 0.00064396858215332
sql: SELECT COUNT(id) FROM courses WHERE Featured = 1, executionMS: 0.00065398216247559
sql: SELECT COUNT(Application_ID) FROM apply, executionMS: 0.045975923538208
.jpg)
