Ticket #19779: example-filter.php

<?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' ) );