Content translation survival rate

SQL

SELECT
    log_id,
    log_page,
    log_timestamp,
    log_actor
FROM
	logging 
    	LEFT JOIN page ON page_id = log_page
        LEFT JOIN change_tag ON ct_log_id=log_id AND ct_tag_id IN ( 
          SELECT ctd_id FROM change_tag_def WHERE ctd_name IN ("contenttranslation", "contenttranslation-v2") 
        )
    actor_logging,
    user
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
GROUP BY log_id
SQL

Checking query status...
