Untitled query #28876

SQL

use arwiki_p;

SELECT 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
and user.user_name not in ('براء', 'مصعب', 'PediAki', 'Rosefaith', 'روان ابوعواد', 'Maha.Jor', 'Elbasyouny', 'عرين أسد أبو رمان')
order by count(distinct page.page_id) desc
SQL

Checking query status...
