Untitled query #73332

SQL

SELECT
    l1.log_id,
    l1.log_title,
    l1.log_page,
    page_id,
    l1.log_timestamp,
    l1.log_actor,
    cx.ct_id,
    comment_text
FROM
	logging as l1
    	LEFT JOIN page ON page_id = l1.log_page AND page_is_redirect IS NOT true
        LEFT JOIN change_tag as cx ON cx.ct_log_id=l1.log_id AND cx.ct_tag_id IN ( 
          SELECT ctd_id FROM change_tag_def WHERE ctd_name IN ("contenttranslation", "contenttranslation-v2") 
        )
        LEFT JOIN change_tag as redirect ON redirect.ct_log_id=l1.log_id AND redirect.ct_tag_id IN ( 
          SELECT ctd_id FROM change_tag_def WHERE ctd_name IN ("mw-new-redirect") 
        )
        LEFT JOIN logging as l2 ON page_id IS NULL AND l1.log_page = l2.log_page AND l2.log_type="delete" AND l2.log_action = "delete" AND l1.log_id<l2.log_id
        LEFT JOIN comment_logging ON l2.log_comment_id=comment_id
        ,
    actor_logging,
    user
WHERE
	l1.log_namespace=0
	AND l1.log_action="create"
    AND actor_id=l1.log_actor
    AND user_id=actor_user
    AND DATEDIFF(STR_TO_DATE(l1.log_timestamp, "%Y%m%d%H%i%s"), STR_TO_DATE(user_registration, "%Y%m%d%H%i%s")) < 365
    AND cx.ct_id IS NULL
    AND redirect.ct_id IS NULL
GROUP BY l1.log_id
SQL

Checking query status...
