<?php
/*
Plugin Name: Example upload.php join filter
Description: Breaks upload.php
Author: Benjamin J. Balter
Version: 1.0
Author URI: http://ben.balter.com
*/

function bb_filter_media_join( $join ) {
		
		$join .= ' LEFT OUTER JOIN wp_trunk_posts bb_post_parent ON bb_post_parent.ID = wp_trunk_posts.post_parent';
		
		return $join;
	}
	
function bb_filter_media_where( $where ) {
	
		$where .= " AND ( bb_post_parent.post_type IS NULL OR bb_post_parent.post_type != 'page' )";
		
		return $where;
		
	}
	
//media filters
add_filter( 'posts_join_paged', array( &$this, 'bb_filter_media_join' ) );
add_filter( 'posts_where_paged', array( &$this, 'bb_filter_media_where' ) );