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 tweets ( id number, uid number, text text, createdate time )
TABLE: CREATE TABLE follows ( f1 number, f2 number )
TABLE: CREATE TABLE user_profiles ( uid number, name text, email text, partitionid number, followers number )

### Question ###
Find the id of users who are followed by Mary and Susan.

### Accurate SQL ###

SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f2 WHERE T1.name = "Mary" INTERSECT SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f2 WHERE T1.name = "Susan"