Magento - Hide ALL simple products that are a child of a configurable product

hideSimpleOfConfigurable.sql

UPDATE
    `catalog_product_entity_int`
SET
    `value` = '1'
WHERE 
    `attribute_id` = (
        SELECT
            `attribute_id` 
        FROM 
            `eav_attribute` 
        WHERE 
            `attribute_code` = 'visibility' 
        AND 
            `entity_type_id` = (
                SELECT 
                    `entity_type_id` 
                FROM 
                    `eav_entity_type` 
                WHERE 
                    `entity_type_code` = 'catalog_product'
            )
    )
AND
    `entity_id` IN (
        SELECT DISTINCT `product_id` FROM `catalog_product_super_link`
    )
AND
    `value` <> '1';