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","P1440","P1447","P1469","P1541","P1663","P1664","P1665","P1666","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","P2778","P2779","P2780","P2800","P2801","P2804","P2805","P2810","P2811","P2818","P2823")
GROUP BY pl_title
ORDER BY count(*) DESC;
SQL

Checking query status...
