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','P2829','P2830','P2857','P2939','P2987',
'P2990','P2991','P3010','P3042','P3043','P3044','P3046','P3047','P3048','P3049','P3050','P3053','P3111')
GROUP BY pl_title
ORDER BY count(*) DESC;
SQL

Checking query status...
