seniori + editace

SQL

use cswiki_p;

select count(*) from (
  
select
  kurzy_seniori.user_id, 
  revision.rev_id, 
  revision.rev_timestamp,
  -- user.user_registration, 
  -- user.user_editcount
  -- page.page_title

from

(
select user.user_id
from ep_users_per_course as users_per_course
join user on user.user_id=users_per_course.upc_user_id
join ep_courses as courses on users_per_course.upc_course_id=courses.course_id
join ep_orgs as orgs on courses.course_org_id=orgs.org_id
where 
	users_per_course.upc_role=0 and 
    (courses.course_title like "%senio%" or courses.course_title like "%Senio%") and 
    datediff(courses.course_start, user.user_registration) >= -14 and 
    datediff(courses.course_start, user.user_registration) <= 14
group by user.user_id
) as kurzy_seniori

inner join revision on revision.rev_user = kurzy_seniori.user_id
-- join page on page.page_id=revision.rev_page
-- join user on kurzy_seniori.user_id=revision.rev_user
where 
  	revision.rev_minor_edit = 0 and 
  	-- page.page_namespace = 0 and 
  	revision.rev_user <> 0
-- order by kurzy_seniori.user_id
;
SQL

Checking query status...
