useful magento 1.9.x sql statements

usefulmagento.sql

#this selects configurable products that don't have any simple products associated with them
select entity_id from `catalog_product_entity` where 'type_id' = 'configurable' AND entity_id NOT IN (SELECT DISTINCT parent_id FROM catalog_product_super_link);


#this selects simple products not associated with a configurable one
select entity_id, sku from catalog_product_entity where type_id = 'simple' AND entity_id NOT IN (SELECT DISTINCT product_id FROM catalog_product_super_link);