Select Testimonials.*, UNIX_TIMESTAMP(Testimonials.Created) as U_Created,
Photos.FileName as PhotoName, Members.FirstName, Members.LastName
FROM Testimonials, Listings, Members
LEFT OUTER JOIN Photos ON Testimonials.ListingId=Photos.ListingId
WHERE Testimonials.ListingId = Listings.ListingId
AND Listings.MemberId = Members.MemberId
AND Photos.ShotNumber=0
Unknown column 'Testimonials.ListingId' in 'on clause'
|
|||||||||||||||||||||||||
|