Websio Cross Query/View for SharePoint 2010

Cross Query and Cross View aggregate data from multiple lists / sites by user-defined query and display it as standard SharePoint view.

Cross Query offers to the end-user ad-hoc Query Builder with ability to save/load previously created queries.

From: WebsioVideo