/* Origin (request): GET http://37.221.209.218/admin/get-zipcode?country=Spain&zipcode=31008
   Query 3 - 2019-07-16 05:38:16 [1078.37ms] */
select `zipcodes`.`city` as `name`, `states`.`name` as `state`, `countries`.`name` as `country` from `zipcodes` left join `cities` on `cities`.`name` = `zipcodes`.`city` left join `states` on `cities`.`state_id` = `states`.`id` left join `countries` on `states`.`country_id` = `countries`.`id` where (`zip` = 31008) and (`country_code` = 'ES');
/*==================================================*/
