This section is for people to post useful queries for specific tasks and searches that are not supported by the built-in search screens.
These queries could form the basis of a report built with the CiviReport reporting framework or a Custom Search.
There are also a number of Joomla extensions that allow creation of specific reports that run from the front end. Specifically some are jamboreport, dbq and jsxas (php5 only). However, to use any of these you need to have a query that works as a starting point.