utiliser une zone de pays pour enregistrement

INSERT IGNORE INTO `fr_hikashop_zone_link`
SELECT 'ship_5000', `address_country` FROM `fr_hikashop_address` 
WHERE `address_country` IS NOT NULL
GROUP BY `address_country`;

UPDATE fr_hikashop_zone SET zone_published = 0 WHERE zone_type= 'country';

UPDATE fr_hikashop_zone a
LEFT JOIN  fr_hikashop_zone_link b
ON a.zone_namekey = b.zone_child_namekey
SET a.zone_published = 1
WHERE b.zone_child_namekey IS NOT NULL 
AND b.zone_parent_namekey LIKE 'ship_5000';

SELECT a.zone_namekey as value, a.zone_name as title
FROM fr_hikashop_zone a 
INNER JOIN fr_hikashop_zone_link b
ON a.zone_namekey = b.zone_child_namekey
WHERE b.zone_parent_namekey LIKE 'ship_5000'
ORDER BY a.zone_name ASC;