Fork of seniori + editace by Hubaceksarka
This query is marked as a draft This query has been published by Hubaceksarka.

SQL

x
 
use cswiki_p;
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=user.user_id
where 
    revision.rev_minor_edit = 0 and 
    revision.rev_user <> 0 and
    page.page_namespace = 0
order by kurzy_seniori.user_id
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...