Skip to content

Instantly share code, notes, and snippets.

@mikegrassotti

mikegrassotti/gist:2712394

Created May 16, 2012 17:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikegrassotti/2712394 to your computer and use it in GitHub Desktop.
Save mikegrassotti/2712394 to your computer and use it in GitHub Desktop.
Download ZIP
cohort activity
Raw
gistfile1.sql
select DATE_FORMAT(u.created_at, '%Y-%m'), DATE_FORMAT(p.published_at, '%Y-%m'), count(*) FROM pfeed_items p, users u where u.id = p.originator_id and p.type IN ('Pfeeds::UserJoinedGroup', 'Pfeeds::UserLeftGroup', 'Pfeeds::UserInvitedUser', 'Pfeeds::UserSharedActivity', 'Pfeeds::UserMessagedGroup', 'Pfeeds::UserPostedItem', 'Pfeeds::UserAttachedTag', 'Pfeeds::UserCreatedBlogPost', 'Pfeeds::UserLikedItem', 'Pfeeds::UserFollowedItem') AND u.created_at > '2012-01-01' AND p.published_at > '2012-01-01' GROUP BY DATE_FORMAT(u.created_at, '%Y-%m'), DATE_FORMAT(p.published_at, '%Y-%m')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment