Copy Image position and label from Store Id 6 to Store ID 5 where position is '2'

magento1_clone_gallery_position_label_new_store

#Copy from Store 6 into Store 5 where position = 2;

INSERT INTO catalog_product_entity_media_gallery_value 
            ( 
                        value_id, 
                        store_id, 
                        label, 
                        position, 
                        disabled 
            ) 
SELECT value_id, 
       store_id, 
       label, 
       position, 
       disabled 
FROM   ( 
              SELECT value_id, 
                     '5' AS store_id, 
                     label, 
                     position, 
                     disabled 
              FROM   catalog_product_entity_media_gallery_value 
              WHERE  store_id = 6 
              AND    position = 2 ) real_query 
on duplicate KEY 
UPDATE value_id=real_query.value_id, 
       store_id=real_query.store_id, 
       label = real_query.label, 
       position = real_query.position, 
       disabled = real_query.disabled;