CREATE TABLE table_34911 ("Version" CLOB, "Length" CLOB, "Album" CLOB, "Remixed by" CLOB, "Year" FLOAT)

Which long version was remixed in 1986?
SELECT "Remixed by" FROM table_34911 WHERE "Year" = '1986' AND "Version" = 'long version'
SELECT "Remixed by" FROM "table_34911" WHERE "Version" = 'long version' AND "Year" = '1986'