/*results.asp case=Series u=*/ SELECT SeriesList.MarkerID, Marker, Memorial INTO #R8352509Series1727012752 FROM SeriesList INNER JOIN Markers ON SeriesList.MarkerID=Markers.MarkerID WHERE SeriesID=0 AND Markers.Rejected Is Null AND Markers.Withdrawn Is Null AND SeriesList.Rejected Is Null AND SeriesList.Withdrawn Is Null AND ReplacedByID Is Null AND (Markers.Accepted Is Not Null OR Markers.CreatedBy=0) AND (SeriesList.Accepted Is Not Null OR SeriesList.CreatedBy=0)