Shock clip shows cattle in Wales residing in appalling conditions