title: Magento SQL query: Get all simple products that are "not visible individually"
body: <p>I am looking to write an SQL query directly on the Magento database that gets all Simple products that have the visibility attribute of "not visible individually", for which the value is 1 i believe.</p>
  
  <p>Can anyone help with this? So far I have discovered that the visibility value is set in the table  </p>
  
  <blockquote>
    <p>catalog_product_entity_int</p>
  </blockquote>
  
  <p>but have been unable to progress further. Thanks</p>