user = mailuser password = mailuserpass hosts = 127.0.0.1 dbname = mailserver query = SELECT CONCAT(`virtual_users`.`username`, '@', `virtual_domains`.`name`) as destination FROM `mailserver`.`virtual_aliases` INNER JOIN `mailserver`.`virtual_users` ON `virtual_users`.`id` = `virtual_aliases`.`user_id` INNER JOIN `mailserver`.`virtual_domains` ON `virtual_domains`.`id` = `virtual_users`.`domain_id` AND `virtual_domains`.`name` = SUBSTRING_INDEX('%s', '@', -1) WHERE `virtual_aliases`.`alias` = SUBSTRING_INDEX('%s', '@', 1);