APPERbot: Fix Wikilink mit Klammerlemma

Fork of APPERbot: Unnötiges :de: aus Wikilink entfernt by Wurgl

This query is marked as a draft This query has been published by Wurgl.

SQL

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS Artikel,
       CONCAT('[[Spezial:Diff/', rev_id, ']]') AS "Diff",
       CONCAT(SUBSTR(rev_timestamp, 1, 4), ' ', SUBSTR(rev_timestamp, 5, 2), ' ', SUBSTR(rev_timestamp, 7, 2), ' ',
              SUBSTR(rev_timestamp, 9, 2), ':', SUBSTR(rev_timestamp, 11, 2), ':', SUBSTR(rev_timestamp, 13, 2)) AS "Timestamp vor APPERbot"
  FROM page, revision, actor AS Bot, comment
 WHERE page_id = rev_page
   AND rev_actor = Bot.actor_id
   AND Bot.actor_name = 'APPERbot'
   AND rev_timestamp >= '20220219220000'
   AND comment_id = rev_comment_id
   AND comment_text LIKE '%Fix Wikilink mit Klammerlemma%'
 ORDER BY rev_timestamp DESC

SQL

Checking query status...