Untitled query #73816

SQL

SELECT WL.page_title AS "Weiterleitung",
       IFNULL(REPLACE(lt_title, "Wikidata-Weiterleitung", "Ja"), "Nein") AS "Vorlage?",
       Q.pp_value AS "WD-Item",
       REPLACE(Badge.pp_propname, "wikibase-badge-", "") AS "WL-Badge",
       Target.page_title AS "Ziel",
       QT.pp_value AS "Ziel-Item"
  FROM redirect,
       page AS Target LEFT JOIN page_props AS QT
                        ON Target.page_id = QT.pp_page
                       AND QT.pp_propname = 'wikibase_item',
       page AS WL LEFT JOIN (templatelinks, linktarget)
                    ON tl_from = WL.page_id
                   AND tl_target_id = lt_id
                   AND lt_title = 'Wikidata-Weiterleitung'
                   AND lt_namespace = 10
                  LEFT JOIN page_props AS Q
                    ON WL.page_id = Q.pp_page
                   AND Q.pp_propname = 'wikibase_item'
                  LEFT JOIN page_props AS Badge
                    ON WL.page_id = Badge.pp_page
                   AND Badge.pp_propname LIKE 'wikibase-badge-%'
 WHERE WL.page_namespace = 0
   AND WL.page_is_redirect = 1
   AND (
        tl_from IS NOT NULL
     OR Q.pp_page IS NOT NULL
     OR Badge.pp_page IS NOT NULL
       )
   AND rd_from = WL.page_id
   AND rd_title = Target.page_title
   AND rd_namespace = Target.page_namespace
 LIMIT 100
SQL

Checking query status...
