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","P2482","P2574","P2593","P2601","P2602","P2640","P2641","P2642","P2648","P2649",
                 "P2685","P2694","P2696","P2697","P2698","P2708",
                 "P2709","P2726","P2727","P2728","P2729","P2730",
                 "P2764","P2767","P2772","P2773","P2774","P2775","P2776","P2777",
                 "P1665","P1440")
GROUP BY pl_title
ORDER BY count(*) DESC;
SQL

Checking query status...
