Untitled query #73342

SQL

SELECT
t.log_id
FROM
(
SELECT 
log_id,
log_page,
page_id,
ct_log_id,
page_is_redirect
FROM
change_tag_def,
change_tag,
logging as l1 LEFT JOIN page ON l1.log_page=page_id
WHERE
log_namespace=0
AND log_id=ct_log_id
AND ct_tag_id=ctd_id
AND ctd_name IN ("contenttranslation", "contenttranslation-v2") 
  AND (page_id IS NULL OR page_is_redirect = true)
GROUP BY log_id
)
as t LEFT JOIN logging as l ON t.page_id=l.log_page AND t.log_id<l.log_id AND l.log_type="delete" AND l.log_action="delete"
WHERE
((l.log_id IS NOT NULL) OR (t.page_is_redirect = true))
GROUP BY t.log_id
SQL

Checking query status...
