SELECT 
    d1.id AS address_id,
    TRIM(BOTH ', ' FROM 
        REPLACE(
            REPLACE(
                CONCAT(
                    IF(d7.name IS NULL OR d7.name = '' OR d7.name = d6.name, '', d7.name),
                    IF(d7.name IS NOT NULL AND d7.name != '' AND d6.name IS NOT NULL AND d6.name != '' AND d7.name != d6.name, ', ', ''),
                    IF(d6.name IS NULL OR d6.name = '' OR d6.name = d5.name, '', d6.name),
                    IF(d6.name IS NOT NULL AND d6.name != '' AND d5.name IS NOT NULL AND d5.name != '' AND d6.name != d5.name, ', ', ''),
                    IF(d5.name IS NULL OR d5.name = '' OR d5.name = d4.name, '', d5.name),
                    IF(d5.name IS NOT NULL AND d5.name != '' AND d4.name IS NOT NULL AND d4.name != '' AND d5.name != d4.name, ', ', ''),
                    IF(d4.name IS NULL OR d4.name = '' OR d4.name = d3.name, '', d4.name),
                    IF(d4.name IS NOT NULL AND d4.name != '' AND d3.name IS NOT NULL AND d3.name != '' AND d4.name != d3.name, ', ', ''),
                    IF(d3.name IS NULL OR d3.name = '' OR d3.name = d2.name, '', d3.name),
                    IF(d3.name IS NOT NULL AND d3.name != '' AND d2.name IS NOT NULL AND d2.name != '' AND d3.name != d2.name, ', ', ''),
                    IF(d2.name IS NULL OR d2.name = '' OR d2.name = d1.name, '', d2.name),
                    IF(d2.name IS NOT NULL AND d2.name != '' AND d1.name IS NOT NULL AND d1.name != '' AND d2.name != d1.name, ', ', ''),
                    IF(d1.name IS NULL OR d1.name = '', '', d1.name)
                ), ', ,', ','
            ), ', ,', ','
        )
    ) AS full_address
FROM martins_address_name d1
RIGHT JOIN martins_address_name d2 ON d1.id = d2.id_address_name
RIGHT JOIN martins_address_name d3 ON d2.id = d3.id_address_name
RIGHT JOIN martins_address_name d4 ON d3.id = d4.id_address_name
RIGHT JOIN martins_address_name d5 ON d4.id = d5.id_address_name
RIGHT JOIN martins_address_name d6 ON d5.id = d6.id_address_name
RIGHT JOIN martins_address_name d7 ON d6.id = d7.id_address_name