Potentiell leere Dateiüberprüfungen

SQL

SELECT CONCAT('Wikipedia:', page_title) AS "Löschkandidat?",
       (SELECT COUNT(*) FROM revision WHERE rev_page = page_id) AS "Anzahl Versionen",
       (SELECT COUNT(*) FROM revision, actor WHERE rev_page = page_id AND rev_actor = actor_id AND actor_name NOT LIKE "%bot" AND actor_name NOT LIKE "%Bot") AS "Anzahl Versionen ohne Bots"
  FROM page LEFT JOIN pagelinks
              ON pl_from = page_id
             AND pl_namespace = 6
 WHERE page_namespace = 4
   AND page_title LIKE "Dateiüberprüfung/Dateiüberprüfung%"
   AND pl_title IS NULL

SQL

Checking query status...