select `s`.`staff_id` AS `ID`,concat(`s`.`first_name`,' ',`s`.`last_name`) AS `name`,`a`.`address` AS `address`,`a`.`postal_code` AS `zip code`,`a`.`phone` AS `phone`,`raivis`.`city`.`city` AS `city`,`raivis`.`country`.`country` AS `country`,`s`.`store_id` AS `SID` from (((`raivis`.`staff` `s` join `raivis`.`address` `a` on(`s`.`address_id` = `a`.`address_id`)) join `raivis`.`city` on(`a`.`city_id` = `raivis`.`city`.`city_id`)) join `raivis`.`country` on(`raivis`.`city`.`country_id` = `raivis`.`country`.`country_id`))