SELECT
    p.entity_id AS product_id,
    ur.request_path AS product_url
FROM
    catalog_product_entity AS p
JOIN
    (
        SELECT
            entity_id,
            MIN(request_path) AS request_path
        FROM
            url_rewrite
        WHERE
            entity_type = 'product'
            AND redirect_type = 0
            AND request_path LIKE '%.html'
            AND request_path NOT LIKE '%/%'
        GROUP BY
            entity_id
    ) AS ur ON p.entity_id = ur.entity_id;

INSERT INTO `url_magento` (`entity_id`, `url`) VALUES (86,"abc-degli-occhi")

UPDATE wpcv_posts
SET post_name = (
    SELECT um.url
    FROM url_magento um
    INNER JOIN wpcv_postmeta wpm ON um.entity_id = wpm.meta_value AND wpm.meta_key = '_magento_id'
    WHERE wpm.post_id = wpcv_posts.ID
)
WHERE ID IN (
    SELECT wpm.post_id
    FROM wpcv_postmeta wpm
    INNER JOIN url_magento um ON wpm.meta_value = um.entity_id AND wpm.meta_key = '_magento_id'
);