Paste P19935

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Urbanecm on Feb 2 2022, 12:30 PM.

Tags

None

Referenced Files

	F34940511: raw-paste-data.txt
	Feb 2 2022, 12:30 PM

Subscribers

None

	REPLACE INTO
	`monuments_all` (
	`country`, `lang`, `id`, `adm0`, `adm1`, `adm2`, `adm3`, `name`, `address`, `municipality`, `lat`, `lon`, `lat_int`, `lon_int`, `image`, `wd_item`, `commonscat`, `source`, `changed`, `monument_article`, `registrant_url`
	) SELECT
	'cz' AS `country`,
	'cs' AS `lang`,
	`id_objektu` AS `id`,
	'cz' AS `adm0`,
	LOWER(`kraj-iso`) AS `adm1`,
	LOWER(`okres-iso`) AS `adm2`,
	`municipality` AS `adm3`,
	`name` AS `name`,
	`address` AS `address`,
	`municipality` AS `municipality`,
	`lat` AS `lat`,
	`lon` AS `lon`,
	ROUND(`lat` * @granularity) AS `lat_int`,
	ROUND(`lon` * @granularity) AS `lon_int`,
	`image` AS `image`,
	`wd_item` AS `wd_item`,
	`commonscat` AS `commonscat`,
	`source` AS `source`,
	`changed` AS `changed`,
	`monument_article` AS `monument_article`,
	`registrant_url` AS `registrant_url`
	FROM `monuments_cz_(cs)`;

(An Untitled Masterwork)ActivePublicActions