Untitled query #28876

SQL

use arwiki_p;

SELECT user.user_name, count(distinct page.page_id)
FROM user, revision, page
WHERE revision.rev_user = user.user_id
AND revision.rev_page = page.page_id
AND page.page_namespace=0
AND page.page_is_redirect=0
AND revision.rev_parent_id =0
AND user.user_id in
  (
    select s.student_user_id from ep_students s, ep_courses c
where s.student_last_course = c.course_id
and c.course_org_id=36
and (c.course_start>=20170819000000 and c.course_end<=20180727000000)
  )
AND revision.rev_timestamp>=20170819000000 and revision.rev_timestamp<=20180727000000
group by user.user_name
SQL

Checking query status...
