sql= SELECT count(*) as recordcount FROM Animals, Pricing, Ancestrypercents, Photos, colors , address, People WHERE animals.speciesID = 19 and animals.PeopleID = People.PeopleID and People.AddressID = address.AddressID And pricing.id=Animals.id and Ancestrypercents.id=Animals.id And Photos.id=Animals.id and Colors.id=Animals.id and subscriptionlevel > 0 and PublishForSale = 1 and people.country_id = 1228

There currently are no Emus that fit that criteria. Please try a different search.