Skip to content

Instantly share code, notes, and snippets.

@gonzaga

gonzaga/gist:5291001

Created April 2, 2013 09:20
Show Gist options
  • Save gonzaga/5291001 to your computer and use it in GitHub Desktop.
Save gonzaga/5291001 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
LEFT OUTER JOIN `taggings` ON `taggings`.`taggable_id` = `landing_pages`.`id` AND taggings.context = 'whitelists' AND `taggings`.`taggable_type` = 'LandingPage' LEFT OUTER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` LEFT OUTER JOIN `taggings` `blacklist_taggings_landing_pages_join` ON `blacklist_taggings_landing_pages_join`.`taggable_id` = `landing_pages`.`id` AND taggings.context = 'blacklists' AND `blacklist_taggings_landing_pages_join`.`taggable_type` = 'LandingPage' LEFT OUTER JOIN `tags` `blacklists_landing_pages` ON `blacklists_landing_pages`.`id` = `blacklist_taggings_landing_pages_join`.`tag_id`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment