sports properties

SQL

select now();

use wikidatawiki_p;
SELECT concat('{{User:Edgars2007/ID/Template|row|',pl_title,'|',count(*),'}}')
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and pl_title in ("P536","P597","P599","P858","P861","P1146","P1238","P1241","P1285","P1364","P1409","P1447",
                 "P1469","P1541","P1663","P1664","P1825","P1826","P1967","P2020","P2090","P2091","P2162",
                 "P2193","P2195","P2276","P2323","P2327","P2328","P2330","P2331","P2350","P2369","P2398",
                 "P2423","P2446","P2447","P2448","P2449","P2458","P2459","P2481","P2574","P2601","P2602",
                 "P1665","P1440")
GROUP BY pl_title
ORDER BY count(*) DESC;
SQL

Checking query status...
