Untitled query #73816

SQL

SELECT WL.page_title, lt_title, Q.pp_value, Badge.pp_propname
  FROM 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 Bagde.pp_page IS NOT NULL
       )
 LIMIT 100
SQL

Checking query status...
