Ad-hoc database queries - This query has not yet been run

Ad-hoc database queries - This query has not yet been run

by sharika ha -
Number of replies: 1

i want to execute ad-hoc database queries to get Most Active Course

here is the query :

SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename

FROM prefix_log l INNER JOIN prefix_course c ON l.course = c.id

GROUP BY courseId

ORDER BY hits DESC


but the query was never executed.

what did i miss?

Attachment Ad-hoc 1.PNG
Attachment Ad-hoc 2.PNG
Average of ratings: -
In reply to sharika ha

Re: Ad-hoc database queries - This query has not yet been run

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers

I am not totally sure what data you seek.  However, you might explore the prefix_logstore_standard_log instead of the prefix_log table.  Logstore contains all user clicks, as I understand it.

Average of ratings: -