twitterface

gistfile1.sql

select users.username, users.location from users where users.user_id in(
  select tweet_mentions.target_user_id from tweet_mentions where tweet_mentions.target_user_id in (
    select users.user_id from users,tweets where tweets.user_id=users.user_id and tweet_text like '%Cancer%' and users.location in ('NY')
  ) 
union select users.user_id from users,tweets where tweets.user_id=users.user_id and tweet_text like '%cancer%' and users.location in ('NY') and users.followers_count > 1000);