Skip to content

Instantly share code, notes, and snippets.

@mrpunkin

mrpunkin/gist:4694401

Last active December 12, 2015 01:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mrpunkin/4694401 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mrpunkin/4694401 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT photos.id FROM photos
LEFT OUTER JOIN votes ON votes.photo_id = photos.id
LEFT OUTER JOIN flags ON flags.photo_id = photos.id AND flags.type="Love"
LEFT OUTER JOIN comments ON comments.photo_id = photos.id
WHERE photos.user_id = 38218
GROUP BY photos.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment