SQL
x
select now();
use wikidatawiki_p;
SELECT page_title,count(*)#concat('{{User:Edgars2007/ID/Template|row|',pl_title,'|',count(*),'}}')
from page
left join pagelinks on pl_title=page_title and pl_from_namespace=0 and pl_namespace=120
where page_namespace=120 and page_is_redirect=0
GROUP BY page_id
ORDER BY count(*) DESC;
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.