Find products w/o images + status and qty

sql_magento_product_w-o_images.sql

SELECT p.sku, p.entity_id, i.value as status, s.qty as qty  
from catalog_product_entity p 
left join catalog_product_entity_int i on p.entity_id = i.entity_id and i.store_id = 0 
left join cataloginventory_stock_item s on p.entity_id =  s.product_id and s.store_id 
where p.entity_id  not in  (SELECT entity_id FROM `catalog_product_entity_varchar` where attribute_id = 87)  
and i.attribute_id = 97  
ORDER BY `status`  DESC