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