jeremywrowe/grouping.rb

Created November 24, 2014 00:41

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jeremywrowe/954d8a93b06b4894c580.js"></script>
Save jeremywrowe/954d8a93b06b4894c580 to your computer and use it in GitHub Desktop.

Download ZIP

MySql Group Concat

Raw

grouping.rb

Customer.joins(subscriptions: :product).group(:email).select('GROUP_CONCAT(DISTINCT subscriptions.state SEPARATOR ":::") AS states, GROUP_CONCAT(DISTINCT products.name SEPARATOR ":::") AS product_names, first_name, last_name').last.states

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment