Untitled query #27025

SQL

use cswiki_p;

select 
	user_id, 
	user_editcount, 
    rev_id, 
    rev_timestamp

FROM (

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,
 	datediff(course_start, user_registration)
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%") and 
  	(datediff(course_start, user_registration) >= -14 and datediff(course_start, user_registration) <= 14) 
as kurzy_seniori

inner join revision
join page on page_id=rev_page
join user on kurzy_seniori.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

) AS whatever;
SQL

Checking query status...
