Skip to content

Instantly share code, notes, and snippets.

@trabulium

trabulium/Mage 1 - SQL find orphan simples with no parent configurable

Created August 1, 2017 04:19
Show Gist options
  • Save trabulium/59cfd5e4e7ac94f928762cb32a88abdc to your computer and use it in GitHub Desktop.
Save trabulium/59cfd5e4e7ac94f928762cb32a88abdc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Mage 1 - SQL find orphan simples with no parent configurable
SELECT * FROM `catalog_product_entity` where entity_id
not in (SELECT product_id FROM `catalog_product_super_link`) and type_id='simple'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment