Skip to content

Instantly share code, notes, and snippets.

@mormegil-cz

mormegil-cz/MostLinkedArticlesDefinedInArticle.sql

Created January 22, 2015 09:09
Show Gist options
  • Save mormegil-cz/709a5c7364a3c7769086 to your computer and use it in GitHub Desktop.
Save mormegil-cz/709a5c7364a3c7769086 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MostLinkedArticlesDefinedInArticle.sql
SELECT linksfromlist.pl_title, (SELECT COUNT(*) FROM pagelinks incominglinks WHERE incominglinks.pl_title=linksfromlist.pl_title AND incominglinks.pl_namespace=linksfromlist.pl_namespace AND incominglinks.pl_from_namespace=0) linkcount
FROM pagelinks linksfromlist
INNER JOIN page ON linksfromlist.pl_from=page_id
WHERE page_namespace=2 AND page_title='Vojtěch_Dostál/Pískoviště3'
AND linksfromlist.pl_namespace=0
ORDER BY linkcount DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment