JOIN vmail_domain d ON u.vmail_domain_id=d.id
WHERE u.username || '@' || d.name = '%s' AND forward IS NOT NULL AND forward <> '' AND active = 1
+Query mit Catchall mittels u.username = '*'
+
+query = SELECT forward
+ FROM vmail_user u
+ JOIN vmail_domain d ON u.vmail_domain_id=d.id
+ WHERE (u.username || '@' || d.name = '%s' OR u.username || '@' || d.name = '*' || substring('%s' from position('@' in '%s')))
+ AND forward IS NOT NULL AND forward <> '' AND active = 1
+
+
virtual-mailbox-domains.cf
user = vmail