Skip to content

Instantly share code, notes, and snippets.

@fwg

fwg/gist:1165150

Created August 23, 2011 13:43
Show Gist options
  • Save fwg/1165150 to your computer and use it in GitHub Desktop.
Save fwg/1165150 to your computer and use it in GitHub Desktop.
Download ZIP
select magento products that have no status
Raw
gistfile1.sql
SELECT
product.entity_id
FROM
catalog_product_entity product
LEFT JOIN catalog_product_entity_int status
ON (status.entity_id=product.entity_id and status.attribute_id=80)
WHERE
status.value IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment