WP Görsel isimlendirme eklentisi

-- Önce mevcut alt etiketleri güncelle
UPDATE wp_postmeta alt_meta
JOIN wp_postmeta thumb_meta ON alt_meta.post_id = thumb_st_meta.post_id
JOIN wp_posts posts ON thumb_meta.meta_value = posts.ID
SET alt_meta.meta_value = posts.post_title
WHERE alt_meta.meta_key = '_wp_attachment_image_alt'
AND thumb_meta.meta_key = '_thumbnail_id';

-- Sonra eksik alt etiketleri ekle
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT thumb_meta.post_id, '_wp_attachment_image_alt', posts.post_title
FROM wp_postmeta thumb_meta
JOIN wp_posts posts ON thumb_meta.meta_value = posts.ID
WHERE thumb_meta.meta_key = '_thumbnail_id'
AND NOT EXISTS (
    SELECT 1 FROM wp_postmeta alt_meta
    WHERE alt_meta.post_id = thumb_meta.post_id
    AND alt_meta.meta_key = '_wp_attachment_image_alt'
);