https://bugzilla.wikimedia.org/show_bug.cgi?id=38319
--- Comment #4 from Maarten Dammers <[email protected]> 2012-07-30 19:55:47 UTC --- Had to do some improvements, but now it seems to work: mysql> SELECT adm0, adm1, COUNT(adm1) FROM `monuments_all` WHERE adm0='cl' GROUP BY adm1; +------+-------+-------------+ | adm0 | adm1 | COUNT(adm1) | +------+-------+-------------+ | cl | CL-AI | 13 | | cl | CL-AN | 47 | | cl | CL-AP | 25 | | cl | CL-AR | 20 | | cl | CL-AT | 24 | | cl | CL-BI | 42 | | cl | CL-CO | 45 | | cl | CL-LI | 42 | | cl | CL-LL | 51 | | cl | CL-LR | 18 | | cl | CL-MA | 36 | | cl | CL-ML | 45 | | cl | CL-RM | 211 | | cl | CL-TA | 57 | | cl | CL-VS | 28 | +------+-------+-------------+ 15 rows in set (0.00 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
