/*results.asp case=Series u=*/ SELECT SeriesList.MarkerID, Marker, Memorial INTO #ResultsTemp FROM SeriesList INNER JOIN Markers ON SeriesList.MarkerID=Markers.MarkerID and SeriesID=0 WHERE Markers.Rejected Is Null AND Markers.Withdrawn Is Null AND SeriesList.Rejected Is Null AND SeriesList.Withdrawn Is Null AND SeriesList.Accepted Is Not Null AND Markers.Accepted is not 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)