title: Magento disable products with no images
body: <p>I am trying to disable a lot of products that do not have images in my Magento installation.</p>
  
  <p>The following SQL query is supposed to get all products with no images but I need a way to set all products with no images to status disabled?</p>
  
  <pre><code>SELECT * FROM catalog_product_entity_media_gallery
          RIGHT OUTER JOIN catalog_product_entity
              ON catalog_product_entity.entity_id = talog_product_entity_media_gallery.entity_id 
     WHERE catalog_product_entity_media_gallery.value is NULL
  </code></pre>