Robert O'Rourke

Adds a simple set of options to modify the default query. Be careful, this affects all list type 
pages on the site and not just the home page.
You can:
<ul>
<li>Customise the post types used</li>
<li>Exclude terms from any taxonomy</li>
<li>Change the ordering</li>
<li>Set an offset to skip posts</li>
<li>Turn paging off</li>
<li>Use a simple meta query</li>
</ul>
Any problems, bugs or feature requests will be answered the quickest on twitter <a href="https://twitter.com/sanchothefat" rel="nofollow ugc">@sanchothefat</a>.

Query Editor

Adds a simple set of options to modify the default query by changing what post types are used, the ordering and more.

Michael Torbert

Once activated, only posts from the current category are displayed in your loop (no posts from sub cats). 
That’s all it does. No options. If you find you need options, let me know and I’ll build them into it.
As of 0.4 I remove the filter after the main query is built so that it doesn’t interfere with widgets. 
If you have a custom query or call wp_query on a category archive template, you’ll need to add and remove the filters before and after your query. Below is an example of how to do this if you use wp_query. Again, this is not necessary unless you have modified queries in a template file.
<pre><code>add_filter( 'posts_where', 'ft_nscp_mod_where' );
query_posts( array( 'your-custom' => 'args' ) );
remove_filter( 'posts_where', 'ft_nscp_mod_where' );
</code></pre>
Its important that you remove what you add.

No Sub-Category Posts in Loops

Once activated, only posts from the current category are displayed in your loop (no posts from sub cats).

Query Editor vs No Sub-Category Posts in Loops