Links to Incubator articles (arwiki)

Fork of Links to English Wikipedia articles (arwiki) by FShbib

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

SQL

USE arwiki_p;
SELECT CONCAT('# [[',page_title,']]') as page_title
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://incubator.wikimedia.org/wiki/%'
OR el_to LIKE 'https://incubator.wikimedia.org/wiki/%')
GROUP BY page_title
ORDER BY page_title;
SELECT CONCAT('# ',el_to) as el_to#, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://incubator.wikimedia.org/wiki/%'
OR el_to LIKE 'https://incubator.wikimedia.org/wiki/%')
GROUP BY el_to
ORDER BY /*counting DESC,*/ el_to;

SQL

Checking query status...