SELECT aux.hits, aux.courseId, c.fullname coursename
FROM
(
SELECT COUNT(l.id) hits, l.course courseId
FROM prefix_log l
WHERE 1=1
%%FILTER_STARTTIME:l.TIME:>%% %%FILTER_ENDTIME:l.TIME:<%%
GROUP BY courseId
) as aux
INNER JOIN prefix_course c ON (c.id=aux.courseId)
I read that the new log table are "prefix_logstore_standard_log", when I change "prefic_log" for "prefix_logstore_standard_log" an error was ocurred, "l.course" don't exist.
Can anyone help me with this?
I need a report with the hits on every course in a range of time.
Thanks for advance