Select DogName,Case DogSex when 'M' then 'Male' else 'Female' end as DogSex,DogState,DogAge,DogDescription, Concat('/dog/',DogLink,'-',DogID,'.html') as DogLink,DogWeight,DogColor,DogEars,DogTail, Case DogNeutered when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as DogNeutered, Case DogShots when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as DogShots, Case OtherDogs when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as OtherDogs, Case Cats when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as Cats, Case Children when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as Children, Case CrateTrained when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as CrateTrained, Case HouseTrained when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as HouseTrained, Case MicroChipped when '1' then 'Yes' when '2' then 'Unknown' else 'No' end as Microchipped, SpecialNeeds,AdoptionFees,DogDescription,AdoptedDate,DateAdded,DogPending From rd_dog_data where Active = '1' and DogID = '117' Order By DateAdded DESC; Select ImageURL from RD_DogImage_Data where DogID = '117' order by PrimaryImage Desc, DateAdded Desc; Select NewsDate,NewsText From RD_DogNews_Data Where DogID = '117' Order By NewsDate Desc;