CREATE TABLE table_54117 ("Tournament" CLOB, "2006" CLOB, "2007" CLOB, "2008" CLOB, "2009" CLOB, "2010" CLOB, "2011" CLOB, "2012" CLOB)

Which tournament had A in 2008, and a 1r in 2010?
SELECT "Tournament" FROM table_54117 WHERE "2008" = 'a' AND "2010" = '1r'
SELECT "Tournament" FROM "table_54117" WHERE "2008" = 'a' AND "2010" = '1r'