repair subscriptions

DELIMITER $$
DROP PROCEDURE IF EXISTS `repair_subscription` $$
CREATE PROCEDURE `repair_subscription`()
BEGIN
DECLARE subscriptionId BIGINT DEFAULT NULL;
DECLARE customerId varchar(20) DEFAULT NULL;
DECLARE done TINYINT DEFAULT FALSE;
DECLARE fixer
    CURSOR FOR
        SELECT p.ID, pmp.meta_value
            FROM wp_posts p
        LEFT OUTER JOIN wp_postmeta pms
            ON p.ID = pms.post_id AND pms.meta_key = "_mollie_customer_id"
        INNER JOIN wp_postmeta pmp
            ON p.post_parent = pmp.post_id AND pmp.meta_key = "_mollie_customer_id"
        WHERE
            p.post_type = "shop_subscription"
            AND pms.meta_value is NULL;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN fixer;
fix_loop:
LOOP
    FETCH NEXT FROM fixer INTO subscriptionId, customerId;
    IF done THEN
        LEAVE fix_loop;
      ELSE
        INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
            VALUES(subscriptionId, "_mollie_customer_id", customerId);
      END IF;
END LOOP;
CLOSE fixer;
END $$
DELIMITER ;
CALL repair_subscription;