SharePoint Email Enabled Lists

The query below when run against the SharePoint content database(s) will display the email alias and the name of the associated list. Hopefully, from the list name you should know where it resides or you can at least search your SharePoint site for it. 

SELECT    tp_EmailAlias as EmailAlias,

tp_Title as ListTitle

FROM        AllLists

INNER JOIN  Webs ON AllLists.tp_WebId = Webs.Id

WHERE       tp_EmailAlias <> ''