nlwiki Gebruiker:Multichill/GevraagdePaginas

Fork of nlwiki Gebruiker:Multichill/GevraagdePaginas by Themanwithnowifi

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

SQL

SELECT CONCAT('* [[', articlelinks.lt_title, ']] - ', COUNT(*))
FROM pagelinks AS articlelinks 
	LEFT JOIN page ON articlelinks.lt_title=page_title AND page_namespace=0 
	LEFT JOIN linktarget AS templinks ON articlelinks.lt_title=templinks.lt_title AND templinks.lt_namespace=0 AND templinks.pl_from_namespace=10
    JOIN pagelinks ON lt_id = pl_target_id
WHERE articlelinks.lt_namespace=0 AND articlelinks.pl_from_namespace=0 AND page_id IS NULL AND templinks.pl_from IS NULL
GROUP BY articlelinks.lt_title
ORDER BY COUNT(*) DESC
LIMIT 10000;

SQL

Checking query status...