Untitled query #72692

SQL

SELECT 
	lg.log_timestamp AS timestamp,  
    pl.pl_title as student,
    p3.page_title AS program_name,
    p3.page_id as program_pageid,
    u.user_id as student_id, 
    u.user_editcount as student_edit_count
FROM logging lg
JOIN page p3 ON log_title = p3.page_title AND p3.page_namespace = 4
JOIN pagelinks pl ON pl.pl_from = p3.page_id AND pl.pl_namespace = 2
JOIN categorylinks cl ON p3.page_id = cl.cl_from AND cl.cl_to like "%Dashboard.wikiedu.org_course_pages%"
JOIN user u ON u.user_name = pl.pl_title
JOIN linktarget lt ON (lt.lt_title LIKE "Dashboard.wikiedu.org_talk_course_link") AND lt.lt_namespace = 10
JOIN templatelinks tl ON lt.lt_id = tl.tl_target_id  
JOIN page p2 ON tl.tl_from  = p2.page_id AND p2.page_namespace = 3 AND p2.page_title NOT like "%/%"
where 
lg.log_type = 'create'
and lg.log_namespace = 4
and lg.log_timestamp<20200101000000 and lg.log_timestamp>20190101000000 
AND u.user_name = p2.page_title
and u.user_registration is NOT NULL
LIMIT 100
SQL

Checking query status...
