CREATE TABLE table_41498 ("Tournament" CLOB, "2004" CLOB, "2005" CLOB, "2006" CLOB, "2007" CLOB, "2008" CLOB, "2009" CLOB, "2010" CLOB, "2011" CLOB)

What 2006 has 1r as the 2007?
SELECT "2006" FROM table_41498 WHERE "2007" = '1r'
SELECT "2006" FROM "table_41498" WHERE "2007" = '1r'