Untitled query #27023

SQL

use cswiki_p;

select user.user_id, revision.rev_id, revision.rev_timestamp, user.user_registration, user.user_editcount
from 
(
select user_id, user_name, user_editcount, upc_course_id, user_registration, course_title, course_start, course_end
from
ep_users_per_course
join user on user_id=upc_user_id
join ep_courses on upc_course_id=course_id
join ep_orgs on course_org_id=org_id
where upc_role=0 and course_title like "%senio%" or course_title like "%Senio%"
) as kurzy_seniori
inner join revision
join page on page_id=rev_page
join user on user_id=rev_user
where revision.rev_minor_edit = 0 and page.page_namespace = 0 and revision.rev_user <> 0 and user.user_registration is not null
order by revision.rev_id
;
SQL

Checking query status...
