registrace behem kurzu

SQL

use cswiki_p;
select 
	user_id, 
    upc_course_id, 
    user_registration, 
    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)
order by datediff(course_start, user_registration)
;
SQL

Checking query status...
