SELECT alias1.* FROM dbmail_aliases as alias1 left join dbmail_aliases as alias2 on alias1.alias = alias2.alias where ISNULL( alias2.alias )