Find Orphan Simple Products without Parent Configurable

find_simple_orphans.sql

select
    type_id,sku, cpev.value
 from catalog_product_entity a
 left join catalog_category_product cp on cp.`product_id` = a.entity_id
 left join catalog_product_relation cpr on cpr.child_id = a.entity_id
 left join catalog_product_entity_varchar cpev on cpev.entity_id = a.entity_id
 left join catalog_product_entity_int cpei on cpei.entity_id = a.entity_id
 where 
# add this if you want to filter by no category
#  cp.product_id is null 
   cpr.parent_id is null
   and a.type_id != 'configurable'
   and cpev.attribute_id = 60
   #visibility attribute = 91 and not visible = 1
   and cpei.attribute_id = 91 and cpei.value = 1;