SELECT REPLACE(page_title, "_", " ") AS title, IF(page_is_redirect,"R","") AS redirect from page, page_props

WHERE page_id = pp_page

  AND pp_propname = "disambiguation"

  AND page_namespace = 0

  AND NOT EXISTS (SELECT 1 FROM templatelinks, linktarget 

                  WHERE tl_from = page_id 

                  AND tl_target_id = lt_id 

                  AND lt_namespace = 10 

                  AND lt_title = "Dmbox"

                 )