WP Education Program contribs

SQL

use arwiki_p;

SELECT distinct (revision.rev_page)
FROM user, revision, page
WHERE revision.rev_user = user.user_id
AND revision.rev_page = page.page_id
AND page.page_namespace=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>=20160601000000 and c.course_end<=20170831000000)
  )
AND revision.rev_timestamp>=20160601000000 and revision.rev_timestamp<=20170531000000

SQL

Checking query status...