Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_36583 ( "Year" real, "Men's singles" text, "Women's singles" text, "Men's doubles" text, "Women's doubles" text, "Mixed doubles" text )

### Question ###
What was the Mixed doubles that has a Women's players of maria gomes zamy gomes, and men's players of fernando silva ricardo fernandes?

### Accurate SQL ###

SELECT "Mixed doubles" FROM table_36583 WHERE "Women's doubles" = 'maria gomes zamy gomes' AND "Men's doubles" = 'fernando silva ricardo fernandes'