nlwiki Disambiguation pages without {{dp}}

Pages that have the magic word __DISAMBIG__ but don't use Template:Dp.
and
Pages that don't have the magic word __DISAMBIG__ but do use Template:Dpintro.

SQL

(SELECT page_namespace AS ns, page_title, '1' AS dp, page_is_redirect AS rd
FROM page, page_props
WHERE 
   page_is_redirect=0 AND page_id=pp_page AND pp_propname='disambiguation' AND
   NOT EXISTS(SELECT * FROM templatelinks,linktarget WHERE tl_target_id=lt_id AND tl_from=page_id AND lt_namespace=10 AND lt_title='Dp')
UNION
SELECT page_namespace, page_title, '0', page_is_redirect
FROM page, templatelinks, linktarget
WHERE 
   page_namespace NOT IN (1,2,3) AND tl_target_id=lt_id AND tl_from=page_id AND lt_namespace=10 AND lt_title='Dpintro' AND
   NOT EXISTS (SELECT * FROM page_props WHERE page_id=pp_page AND pp_propname='disambiguation')
) ORDER BY ns, page_title

SQL

Checking query status...