Eventuell Normdaten entfernt

SQL

SELECT DISTINCT page_title, n_rev.rev_timestamp, p_rev.rev_len - n_rev.rev_len AS "Bytes entfernt", actor_name, comment_text
  FROM revision AS p_rev, revision AS n_rev, actor, comment,
       page LEFT JOIN (templatelinks, linktarget)
              ON tl_from = page_id
             AND tl_target_id = lt_id
             AND lt_namespace = 10
             AND lt_title = 'Normdaten'
            LEFT JOIN page_props
              ON pp_page = page_id
             AND pp_propname = 'disambiguation'
            LEFT JOIN categorylinks
              ON cl_from = page_id
             AND cl_to IN ('Mann', 'Frau')
 WHERE page_namespace = 0
   AND page_title NOT LIKE "Liste_%"
   AND page_title NOT LIKE "Nekrolog_%"
   AND page_title NOT LIKE "Sportjahr_%"
   AND page_title NOT LIKE "Filmjahr_%"
   AND page_title NOT LIKE "%/Episodenliste"
   AND p_rev.rev_page = page_id
   AND n_rev.rev_page = page_id
   AND n_rev.rev_id = p_rev.rev_parent_id
   AND n_rev.rev_timestamp LIKE '20241103%'
   AND p_rev.rev_len > n_rev.rev_len + 30
   AND p_rev.rev_len < n_rev.rev_len + 100
   AND n_rev.rev_actor = actor_id
   AND n_rev.rev_comment_id = comment_id
   AND actor_name != 'APPERbot'
   AND tl_from IS NULL # kein Template Normdaten
   AND pp_page IS NULL # keine BKL
   AND cl_from IS NULL # keine Personen
 GROUP BY page_id, actor_id
SQL

Checking query status...
