Skip to content

Instantly share code, notes, and snippets.

@radar

radar/taxons.sql

Created June 5, 2012 04:22
Show Gist options
  • Save radar/2872626 to your computer and use it in GitHub Desktop.
Save radar/2872626 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
taxons.sql
SELECT spree_products.* FROM "spree_products"
INNER JOIN "spree_products_taxons" ON "spree_products_taxons"."product_id" = "spree_products"."id"
WHERE "spree_products_taxons"."taxon_id" = 2000
INTERSECT
SELECT spree_products.* FROM "spree_products"
INNER JOIN "spree_products_taxons" ON "spree_products_taxons"."product_id" = "spree_products"."id"
WHERE "spree_products_taxons"."taxon_id" = 31989848
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment