Need a query to get all entities names of all espaces belong to one Application.

I have created a application where there are 30 espaces .I need a query which can give me all the entities in all espaces belonging to this application.

Look in System, you will see the "Application" Entity, join to App_Definition_Module, join to Module, which can then be joined to Espace or Extension entities as needed.