SQL
AخA
USE fawiki_p;
SELECT DISTINCT pl_title,count(*)
FROM pagelinks INNER JOIN page ON pl_from = page_id
WHERE pl_namespace = 0
AND page_namespace = 0
AND pl_title IN (
SELECT page_title
FROM page AS frst
WHERE frst.page_namespace = 0
AND frst.page_is_redirect=1
AND frst.page_title NOT LIKE "%•%"
AND EXISTS (
SELECT null
FROM page AS scnd
WHERE scnd.page_namespace=0
AND scnd.page_is_redirect=0
AND frst.page_title = REPLACE(scnd.page_title,'•','')
)
)
GROUP BY pl_title
ORDER BY count(*) DESC;
#ORDER BY pl_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.