smashing pumpkins is one of the favorite freebase topics for which user profile?
(AND freebase.user_profile (JOIN freebase.user_profile.favorite_topics m.07r1_))