Magento - Disable configurable products without image, through SQL direct query

disable_products_without_image.sql

UPDATE catalog_product_entity_int SET value = 2 
WHERE attribute_id = (
	SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'status' AND entity_type_id = (
		SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product'
	)
)
AND entity_id IN (
        SELECT catalog_product_entity.entity_id 
        FROM catalog_product_entity_media_gallery
        RIGHT OUTER JOIN catalog_product_entity ON catalog_product_entity.entity_id = catalog_product_entity_media_gallery.entity_id 
        WHERE catalog_product_entity_media_gallery.value is NULL
        AND catalog_product_entity.type_id = 'configurable'
)