Moodle SQL for users who never have logged in

Simple query that works with postgres to find users who have not logged in.

select * from mdl_user where not exists (select * from mdl_user_lastaccess where mdl_user.id =  mdl_user_lastaccess.id);

Comments

Comments powered by Disqus