https://bugzilla.wikimedia.org/show_bug.cgi?id=38328
Maarten Dammers <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #8 from Maarten Dammers <[email protected]> 2012-09-06 18:57:18 UTC --- Done mysql> REPLACE INTO `monuments_all` (`country`, `lang`, `id`, `adm0`, `adm1`, `adm2`, `adm3`, `adm4`, `name`, `address`, `municipality`, `lat`, `lon`, `lat_int`, `lon_int`, `image`, `source`, `changed`, `monument_article`, `registrant_url` ) -> SELECT 'ph' AS `country`, -> 'en' AS `lang`, -> `cp-wmph-id` AS `id`,'ph' AS `adm0`,`region-iso` AS `adm1`,`province` AS `adm2`, /* province-iso is still empty, could be used later */`location` AS `adm3`,NULL AS `adm4`, -> `site_name` AS `name`, -> `address` AS `address`, -> `location` AS `municipality`, -> `lat` AS `lat`, -> `lon` AS `lon`, -> ROUND(`lat` * @granularity) AS `lat_int`, -> ROUND(`lon` * @granularity) AS `lon_int`, -> `image` AS `image`, -> NULL AS `source`, -> `changed` AS `changed`, -> NULL AS `monument_article`, -> NULL AS `registrant_url` -> FROM `monuments_ph_(en)`; Query OK, 687 rows affected, 2061 warnings (1 min 16.77 sec) Records: 687 Duplicates: 0 Warnings: 2061 -- 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
