Untitled query #72692

SQL

SELECT 
	log_timestamp AS timestamp,  
    log_namespace AS namespace,
    log_title AS page,
    student,
    program_name,
    program_pageid
FROM logging_userindex
JOIN comment_logging ON log_comment_id = comment_id
JOIN actor_logging ON log_actor = actor_id
JOIN user_groups ON actor_user = ug_user 
JOIN 
    (select * 
    select pl.pl_title as student,
    p3.page_title as program_name
    pl.page_id as program_pageid
    from 
    pagelinks pl
    inner join page p3
    on pl.pl_from = p3.page_id
    where p3.page_id in
        (select cl.cl_from#, cl.cl_to, cl.cl_timestamp 
         from categorylinks cl
         where cl.cl_to like "%Dashboard.wikiedu.org_course_pages%")
         and p3.page_namespace = 4
         and pl.pl_namespace = 2
         limit 10)
    WHERE 
        log_type = 'create'
        and log_namespace = 4
    )
    ON program_name = log_title
    LIMIT 100
SQL

Checking query status...
