Skip to main content
edited tags
Link
Source Link

How to add product name to SQL Query

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