mp2.1 DAB pages containing external links/references

Fork of mp2.1 DAB pages containing external links/references by Saeidpourbabak

This query is marked as a draft This query has been published by Estopedist1.

SQL

USE etwiki_p;
(SELECT CONCAT ('# [[',REPLACE(page_title,'_',' '),']]')
FROM page
WHERE page_namespace=0
AND page_id IN (
  SELECT el_from FROM externallinks
  WHERE el_from IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation'
  )
)
)
UNION
(
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')#,tl_title
FROM page JOIN templatelinks ON page_id=tl_from
WHERE page_is_redirect=0
AND page_namespace=0
AND tl_namespace = 10
AND page_id IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)
#AND (tl_title LIKE "یادکرد%"
#     OR tl_title LIKE "پانویس"
)
)
LIMIT 5;

SQL

Checking query status...