Wilson Lake Classifieds Category

SELECT C.*, GP.PhotoID, MP.ServerID, MP.FolderID FROM Classifieds C LEFT JOIN GalleryPhoto GP ON GP.GalleryID = C.GUID LEFT JOIN MemberPhotos MP ON MP.PhotoID = GP.PhotoID WHERE ClassifiedsCategoryID = 24 AND (C.Status IS NULL OR C.Status IN ('N','C')) AND DateChanged >= '12/22/2012' AND (GP.PhotoID IS NULL OR GP.PhotoOrder = 1) ORDER BY DateAdded Desc Wilson Lake Classifieds Category