added connection details and query for retrieving sponsoring lir emails