/*results.asp case=Series u=*/ SELECT SeriesList.MarkerID, Marker, Memorial INTO #R6632405Series17270130223 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)