Which player debuted in 1973 against Limerick and played his last game at the Munster semi-final?
CREATE TABLE "retirees" (
  "player" text,
  "team" text,
  "last_game" text,
  "date" text,
  "opposition" text,
  "d_but" real
);
SELECT "player" FROM "retirees" WHERE "opposition"='limerick' AND "last_game"='munster semi-final' AND "d_but"=1973;