Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P19935
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Urbanecm
on Feb 2 2022, 12:30 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F34940511: raw-paste-data.txt
Feb 2 2022, 12:30 PM
2022-02-02 12:30:27 (UTC+0)
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)`;
Event Timeline
Urbanecm
created this paste.
Feb 2 2022, 12:30 PM
2022-02-02 12:30:27 (UTC+0)
Stashbot
mentioned this in
T300252: 78 datasets fail harvest because `"title() takes 1 positional argument but 2 were given`
.
Feb 2 2022, 12:30 PM
2022-02-02 12:30:47 (UTC+0)
Log In to Comment