select p.product, p.shortdesc, p.longdesc, case when img.ContentPath is null then 755 else p.imgId end as imgId, img.ContentPath, i.filewidth FROM tbl_PRD_Products p LEFT OUTER JOIN tbl_IMG_Images i ON i.imgid = p.imgid LEFT OUTER JOIN qryContentFullPathLookup img on img.contentId = i.contentId WHERE p.ProdID = AND p.OwnerID = AND p.FSL_TableCode = AND #CreateODBCDate(Now())# >= p.PublishDate AND p.UnpublishDate >= #CreateODBCDate(Now())#