SELECT
`t_working_field`.`wf_id`,
`t_country`.`country_name_en`,
`t_city`.`city_name_en`,
`t_type`.`type_name_en`
FROM
`t_working_field`
Inner Join `t_working_field_location` ON `t_working_field`.`wf_id` = `t_working_field_location`.`wf_id`
Inner Join `t_working_field_type` ON `t_working_field`.`wf_id` = `t_working_field_type`.`wf_id` ,
`t_city`
left Join `t_country` ON `t_working_field_location`.`country_id` = `t_country`.`country_id` AND `t_country`.`country_id` = `t_city`.`country_id`
left Join `t_type` ON `t_working_field_type`.`type_id` = `t_type`.`type_id`