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
JOIN pagelinks pl ON pl.pl_from = p3.page_id
JOIN categorylinks cl ON p3.page_id = cl.cl_from
JOIN user u ON u.user_name = pl.pl_title
where p3.page_namespace = 4
AND pl.pl_namespace = 2
AND cl.cl_to like "%Dashboard.wikiedu.org_course_pages%"
AND lg.log_type = 'create'
and lg.log_namespace = 4
and lg.log_timestamp<20190101000000
LIMIT 100
SQL

Checking query status...
