Ticket #18858: get.txt

function get_post_type_objects_in_term( $term_ids, $post_types, $taxonomies, $args = array() ) {

        global $wpdb;

        if ( ! is_array( $term_ids ) )
                $term_ids = array( $term_ids );

        if ( ! is_array( $taxonomies ) )
                $taxonomies = array( $taxonomies );

        foreach ( (array) $taxonomies as $taxonomy ) {
                if ( ! taxonomy_exists( $taxonomy ) )
                        return new WP_Error( 'invalid_taxonomy', __( 'Invalid Taxonomy' ) );
        }

        if ( ! is_array( $post_types ) )
                $post_types = array( $post_types );

        foreach ( (array) $post_types as $post_type ) {
                if ( ! post_type_exists( $post_type ) )
                        return new WP_Error( 'invalid_post_type', __( 'Invalid Post Type' ) );
        }

        $defaults = array( 'order' => 'ASC' );
        $args = wp_parse_args( $args, $defaults );
        extract( $args, EXTR_SKIP );

        $order = ( 'desc' == strtolower( $order ) ) ? 'DESC' : 'ASC';

        $term_ids = array_map('intval', $term_ids );

        $post_types = "'" . implode( "', '", $post_types ) . "'";
        $taxonomies = "'" . implode( "', '", $taxonomies ) . "'";
        $term_ids = "'" . implode( "', '", $term_ids ) . "'";

        $object_ids = $wpdb->get_col("SELECT tr.object_id FROM $wpdb->posts AS p INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND tt.term_id IN ($term_ids) AND p.post_type IN ($post_types) ORDER BY tr.object_id $order");

        if ( ! $object_ids )
                return array();

        return $object_ids;
}