SQL statement to get a list of enabled products that are not in any categories

prodsnotinanycategory.sql

SELECT cpe.entity_id, 
       cpe.sku 
FROM   catalog_product_entity AS cpe 
       LEFT JOIN catalog_category_product AS ccp 
              ON cpe.entity_id = ccp.product_id 
       LEFT JOIN catalog_product_entity_int AS cpi 
              ON cpe.entity_id = cpi.entity_id 
WHERE  category_id IS NULL 
       AND attribute_id = (SELECT attribute_id 
                           FROM   `eav_attribute` 
                           WHERE  `attribute_id` LIKE '80') 
       AND cpi.value = 1