Untitled query #73332

SQL

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

Checking query status...
