SELECT ma.name, ma.id as stagingId, mat.id as testshopId
FROM s_media_album ma
LEFT JOIN s_media_album_testshop mat ON ma.name = mat.name
WHERE ma.name = 'Sideboard Freisteller'

UPDATE s_media m
SET m.albumID = 38
WHERE m.name IN (
    SELECT mt.name
    FROM s_media_testshop mt
    LEFT JOIN s_media_album_testshop mat ON mt.albumID = mat.id
    WHERE mat.id = 46
)