Configurable reports block (plugin)

Hi, I have a report configured in a older version of moodle, now I have the moodle 3.0.2 version and the report isn't work, the SQL query is :

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