Skip to content

Instantly share code, notes, and snippets.

@cigoe

cigoe/gist:3716288

Created September 13, 2012 18:06
Show Gist options
  • Save cigoe/3716288 to your computer and use it in GitHub Desktop.
Save cigoe/3716288 to your computer and use it in GitHub Desktop.
Download ZIP
Find all Magento products where "Links can be purchased separately" is set to yes in a single store install
Raw
gistfile1.sql
SELECT main.sku as sku
FROM catalog_product_flat_1 AS main
INNER JOIN catalog_product_entity_int AS cat_int ON main.entity_id = cat_int.entity_id
WHERE cat_int.attribute_id = 503 AND cat_int.value = 1 AND main.type_id = 'downloadable'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment