Untitled query #76978

SQL

SELECT P.page_title
  FROM templatelinks as PT,
       linktarget AS PL,
       page AS P LEFT JOIN page_props AS PP
                   ON PP.pp_page = P.page_id
                  AND PP.pp_propname = 'disambiguation'
                 LEFT JOIN (pagelinks, page AS L LEFT JOIN page_props AS LP
                                                   ON LP.pp_page = L.page_id
                                                  AND LP.pp_propname = 'disambiguation'
                                                 LEFT JOIN (templatelinks AS LT, linktarget AS LL)
                                                   ON LT.tl_from = L.page_id
                                                  AND LT.tl_target_id = LL.lt_id
                                                  AND LL.lt_namespace = 10
                                                  AND LL.lt_title = 'Normdaten'
                           )
                   ON pl_from = P.page_id
                  AND pl_title = L.page_title
                  AND pl_namespace = L.page_namespace
                  AND pl_namespace = 0
                  AND LP.pp_page IS NULL
                  AND LT.tl_from IS NULL
 WHERE P.page_namespace = 0
   AND PP.pp_page IS NULL
   AND pl_from IS NULL
   AND PT.tl_from = P.page_id
   AND PT.tl_target_id = PL.lt_id
   AND PL.lt_namespace = 10
   AND PL.lt_title = 'Normdaten'
SQL

Checking query status...
