Add visibility for missing products - woocommerce

INSERT INTO wp_postmeta (`meta_id`, `post_id`, `meta_key`, `meta_value`)

    SELECT DISTINCT
    NULL AS meta_id,
    stock.post_id AS post_id,
    '_visibility' AS meta_key,
    'visible' AS meta_value
FROM wp_postmeta stock_status
INNER JOIN wp_posts ON wp_posts.ID = stock_status.post_id
INNER JOIN wp_postmeta stock ON wp_posts.ID = stock.post_id
LEFT JOIN (
    SELECT DISTINCT stock.post_id, stock.meta_value AS stock, stock_status.meta_value AS stock_status, visibility.meta_value AS visibility
    FROM wp_postmeta stock_status
    INNER JOIN wp_posts ON wp_posts.ID = stock_status.post_id
    INNER JOIN wp_postmeta stock ON wp_posts.ID = stock.post_id
    LEFT JOIN wp_postmeta visibility ON stock_status.post_id = visibility.post_id
    WHERE stock_status.meta_key = '_stock_status'
        AND stock_status.meta_value='instock'
        AND visibility.meta_key='_visibility'
        AND stock.meta_key='_stock'
        AND stock.meta_value > 0
        AND wp_posts.post_status='publish'
) AS visibles ON visibles.post_id = stock.post_id
WHERE stock_status.meta_key = '_stock_status'
    AND stock_status.meta_value='instock'
    AND stock.meta_key='_stock'
    AND stock.meta_value > 0
    AND visibles.post_id IS NULL
    AND wp_posts.post_status='publish';