https://bugzilla.wikimedia.org/show_bug.cgi?id=39891
Maarten Dammers <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #2 from Maarten Dammers <[email protected]> 2012-09-01 17:15:56 UTC --- CONCAT('it-',`regione`) AS `adm1`, should fix this. mysql> SELECT DISTINCT(adm1) FROM monuments_all WHERE country='it' AND lang='it' AND adm0= 'it'; +-------+ | adm1 | +-------+ | it-07 | | it-18 | | it-01 | | it-03 | | it-04 | | it-05 | | it-06 | | it-08 | | it-11 | | it-09 | | it-10 | | it-12 | | it-15 | | it-13 | | it-14 | | it-02 | | it-16 | | it-17 | | it-19 | | it-20 | +-------+ 20 rows in set (0.00 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
