What 2008 has 1r as a 2010, A as the 2007, and 1r as the 2009?
CREATE TABLE "singles_performance_timeline" (
  "tournament" text,
  "2006" text,
  "2007" text,
  "2008" text,
  "2009" text,
  "2010" text,
  "2011" text,
  "2012" text
);
SELECT "2008" FROM "singles_performance_timeline" WHERE "2010"='1r' AND "2007"='a' AND "2009"='1r';