What was the regular season standings for the year when the playoffs reached the conference semifinals and the team did not qualify for the US Open Cup?
CREATE TABLE "year_by_year" (
  "year" real,
  "league" text,
  "reg_season" text,
  "playoffs" text,
  "us_open_cup" text,
  "avg_attendance" real
);
SELECT "reg_season" FROM "year_by_year" WHERE "playoffs"='Conference Semifinals' AND "us_open_cup"='Did not qualify';