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

 LIMIT 10