Skip to content

Instantly share code, notes, and snippets.

@chrishomer

chrishomer/gist:4560471

Created January 17, 2013 22:32
Show Gist options
  • Save chrishomer/4560471 to your computer and use it in GitHub Desktop.
Save chrishomer/4560471 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
ItemEvent.where("item_events.created_at > ? AND item_events.created_at < ?",Time.parse("January 15 2013"),Time.parse("January 16 2013")).select("COUNT(DISTINCT item_events.item_id) AS cnt").first.cnt
=> 1979
Item.where("items.created_at > ? AND items.created_at < ?",Time.parse("January 15 2013"),Time.parse("January 16 2013")).count
=> 2739
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment