[ 'FindLocation' ] =
[[
    select      location.start as start,
                location.end as end,
                city.name as city,
                region.name as region,
                region.code as region_code,
                country.name as country,
                country.code as country_code
    from        location
    join        city on city.id = location.city_id
    join        region on region.id = city.region_id
    join        country on country.id = region.country_id
    where       location.start <= %s
    order by    location.start desc
    limit       1
]]