Sql=select animals.ID, Category, Color1, Color2, Color3, Color4, Color5, Photo1, Photo2, Photo3, Photo4, Photo5, Photo6, Photo7, Photo8, studfee, PriceComments, SalePending, Sold, Free, ShowPrices, price, discount, fullname, DOBDay, DOBMonth, DOBYear, Sire, Dam from Animals, Pricing, Colors, Photos, ancestors where Animals.ID = Pricing.ID and Animals.ID = ancestors.ID and Animals.ID = Photos.ID and Animals.ID = Colors.ID and sold = 0 and PublishForSale = 1 and PeopleID= 1940 and speciesID = 2 order by DOBYear Desc, DOBMonth Desc
|
