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