allproductsallwebsites.sql

INSERT INTO
    catalog_product_website (website_id, product_id)
SELECT
    sw.website_id,
    cpw.product_id
FROM
    store_website sw
        JOIN (
            SELECT
                cpwd.product_id
            FROM
                catalog_product_website cpwd
            GROUP BY
                cpwd.product_id
            HAVING count(cpwd.product_id) = 1
        ) cpw
WHERE
    sw.website_id != 0 AND sw.website_id != 1;