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