INSERT INTO variable_mappings (variable_id, designation_id, class_id, value)
    SELECT variable_definitions.id as 'variable',
           designation_definitions.id as 'designation',
           class_definitions.id as 'class'
    FROM variable_definitions
    JOIN designation_definitions on designation_definitions.name='development'
    JOIN class_definitions on class_definitions.name='av-control'
    WHERE variable_definitions.name='CONFIGURATION-DATABASE-MICROSERVICE-ADDRESS';