SELECT BCLocalName, BCPresentUse, tcountry.CountryId AS tcountry_CountryId, CountryName, tbreed.BRId AS tbreed_BRId, BRNameStrain, BRNameSynonym, BRSubGroupInfo, tspecies.SId AS tspecies_SId, SName, GName FROM (tbreedcountry INNER JOIN tcountry ON tbreedcountry.CountryId = tcountry.CountryId) INNER JOIN ((tbreed INNER JOIN tgroup ON tbreed.GId = tgroup.GId) INNER JOIN tspecies ON tgroup.SId = tspecies.SId) ON tbreedcountry.BRId = tbreed.BRId
tbreedcountry.CountryId In (70)
DAGRIS
