SQL Vínculo de Imagens Magento

magento_vincular_imagens.sql

/*
* Este UPDATE faz o vinculo da segunda imagem (mgv.position) com o atributo small_image (86)
* 85, 86, 87 -> base_image, small_image, thumbnail
* OS ID's variam de cada base Magento, verifique na tabela eav_attribute.
*/
UPDATE catalog_product_entity_media_gallery AS `mg`,
    catalog_product_entity_media_gallery_value AS `mgv`,
    catalog_product_entity_varchar AS `ev`
SET `ev`.`value` = `mg`.`value`
WHERE  `mg`.`value_id` = `mgv`.`value_id`
    AND `mg`.`entity_id` = `ev`.`entity_id`
    AND `ev`.`attribute_id` IN (86) 
    AND `mgv`.`position` = 2;