puedes intentar:
Código PHP:
//
SELECT po.provider_name, po.website, co.phone_code, IFNULL(max(re.status_2),'No Contacted') as status_2
FROM remarks re RIGHT JOIN ( provider po RIGHT JOIN countries co ON (co.name=po.country) ) ON (re.provider_id=po.provider_id)
GROUP BY po.provider_id
saludos..., cya