What year did maggs magnificent mild win a gold medal in the mild and porter category at the siba south east region beer competition?
CREATE TABLE "awards" (
  "year" real,
  "beer_name" text,
  "prize" text,
  "category" text,
  "competition" text
);
SELECT AVG("year") FROM "awards" WHERE "beer_name"='maggs magnificent mild' AND "prize"='gold medal' AND "category"='mild and porter' AND "competition"='siba south east region beer competition';