I want to turn the SQL below into a Zend Db query.
Select * from catalog_product_entity where entity_id not in ( select Distinct(product_id) from sales_flat_order_item)
Can anyone help me with this, I am currently new to magento and it still confuse me. Any help is appreciated.