Untitled query #27025

SQL

use cswiki_p;

  select 
	user.user_id, 
    users_per_course.upc_course_id, 
    user.user_registration, 
    courses.course_start, 
    courses.course_end, 
    orgs.datediff(course_start, user_registration),
  	user.user_editcount
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=ep_courses.course_id 
join ep_orgs as orgs on ep_courses.course_org_id=ep_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
 order by datediff(courses.course_start, user.user_registration)
limit 100;
SQL

Checking query status...
