What is the competition on 15 August 2008?
CREATE TABLE "pre_season_and_friendlies" (
  "date" text,
  "time" text,
  "competition" text,
  "opponent" text,
  "ground" text,
  "score" text
);
SELECT "competition" FROM "pre_season_and_friendlies" WHERE "date"='15 august 2008';