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 ('536','597','599','858','861','1146','1238','1241','1285','1364','1409','1440','1447','1469','1541','1663','1664','1665','1666','1825','1826','1967','2020','2090','2091','2162','2193','2195','2276','2323','2327','2328','2330','2331','2350','2369','2398','2423','2446','2447','2448','2449','2458','2459','2481','2482','2574','2593','2601','2602','2640','2641','2642','2648','2649','2685','2694','2696','2697','2698','2708','2709','2726','2727','2728','2729','2730','2764','2767','2772','2773','2774','2775','2776','2777','2778','2779','2780','2800','2801','2804','2805','2810','2811','2818','2823','2829','2830','2857','2939','2987','2990','2991','3010','3042','3043','3044','3046','3047','3048','3049','3050','3053','3111')
GROUP BY pl_title
ORDER BY count(*) DESC;
SQL

Checking query status...
