General developer forum

 
 
Picture of Alexandr Zhuikov
Re: how sql query with moodle
 

In my script:

replace ... INNER JOIN mdl_log L ON U.id = L.userid ...

with ... INNER JOIN {log} L ON U.id = L.userid ...

It'll be work fine, when you want to change DB table's prefix.

 
Average of ratings: -