Skip to content

Instantly share code, notes, and snippets.

@burin

burin/gist:26326

Created November 18, 2008 23:11
Show Gist options
  • Save burin/26326 to your computer and use it in GitHub Desktop.
Save burin/26326 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
--most referred questions in the past 7 days
select q.question, q.created_at as asked_on,count(1) as referrals from question_referrals r, questions q where r.question_id=q.id and r.created_at>SUBDATE(CURRENT_DATE(), INTERVAL 7 DAY) group by r.question_id order by referrals desc, asked_on desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment