Skip to content

Instantly share code, notes, and snippets.

@yyl

yyl/gist:3195607

Created July 29, 2012 01:24
Show Gist options
  • Save yyl/3195607 to your computer and use it in GitHub Desktop.
Save yyl/3195607 to your computer and use it in GitHub Desktop.
Download ZIP
twitterface
Raw
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment