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= 485 and speciesID = 2 order by DOBYear Desc, DOBMonth Desc
|
