SELECT entity_id, sku , type_id
FROM catalog_product_entity
WHERE entity_id NOT IN (
SELECT product_id
FROM `sales_flat_order_item`
)
ORDER BY sku
Need to include product name with above SQL Query and unsure how to format the join.
Magento 1.9.3.2