{

/**

* Execute the query

*

* @since 3.1.0

*

* @param string|array $query_vars

* @return int|array

*/

function query( $query_vars ) {

global $wpdb;

$defaults = array(

'author_email' => '',

'ID' => '',

'karma' => '',

'number' => '',

'offset' => '',

'orderby' => '',

'order' => 'DESC',

'parent' => '',

'post_ID' => '',

'post_id' => 0,

'post_author' => '',

'post_name' => '',

'post_parent' => '',

'post_status' => '',

'post_type' => '',

'tax_query' => '',

'status' => '',

'type' => '',

'user_id' => '',

'search' => '',

'count' => false

);

$this->query_vars = wp_parse_args( $query_vars, $defaults );

do_action_ref_array( 'pre_get_comments', array( &$this ) );

extract( $this->query_vars, EXTR_SKIP );

// $args can be whatever, only use the args defined in defaults to compute the key

$key = md5( serialize( compact(array_keys($defaults)) ) );

$last_changed = wp_cache_get('last_changed', 'comment');

if ( !$last_changed ) {

$last_changed = time();

wp_cache_set('last_changed', $last_changed, 'comment');

}

$cache_key = "get_comments:$key:$last_changed";

if ( $cache = wp_cache_get( $cache_key, 'comment' ) ) {

return $cache;

}

$post_id = absint($post_id);

if ( 'hold' == $status )

$approved = "comment_approved = '0'";

elseif ( 'approve' == $status )

$approved = "comment_approved = '1'";

elseif ( 'spam' == $status )

$approved = "comment_approved = 'spam'";

elseif ( 'trash' == $status )

$approved = "comment_approved = 'trash'";

else

$approved = "( comment_approved = '0' OR comment_approved = '1' )";

$order = ( 'ASC' == strtoupper($order) ) ? 'ASC' : 'DESC';

if ( ! empty( $orderby ) ) {

$ordersby = is_array($orderby) ? $orderby : preg_split('/[,\s]/', $orderby);

$ordersby = array_intersect(

$ordersby,

array(

'comment_agent',

'comment_approved',

'comment_author',

'comment_author_email',

'comment_author_IP',

'comment_author_url',

'comment_content',

'comment_date',

'comment_date_gmt',

'comment_ID',

'comment_karma',

'comment_parent',

'comment_post_ID',

'comment_type',

'user_id',

)

);

$orderby = empty( $ordersby ) ? 'comment_date_gmt' : implode(', ', $ordersby);

} else {

$orderby = 'comment_date_gmt';

}

$number = absint($number);

$offset = absint($offset);

if ( !empty($number) ) {

if ( $offset )

$limits = 'LIMIT ' . $offset . ',' . $number;

else

$limits = 'LIMIT ' . $number;

} else {

$limits = '';

}

if ( $count )

$fields = 'COUNT(*)';

else

$fields = '*';

$join = '';

$where = $approved;

if ( ! empty($post_id) )

$where .= $wpdb->prepare( ' AND comment_post_ID = %d', $post_id );

if ( '' !== $author_email )

$where .= $wpdb->prepare( ' AND comment_author_email = %s', $author_email );

if ( '' !== $karma )

$where .= $wpdb->prepare( ' AND comment_karma = %d', $karma );

if ( 'comment' == $type ) {

$where .= " AND comment_type = ''";

} elseif( 'pings' == $type ) {

$where .= ' AND comment_type IN ("pingback", "trackback")';

} elseif ( ! empty( $type ) ) {

$where .= $wpdb->prepare( ' AND comment_type = %s', $type );

}

if ( '' !== $parent )

$where .= $wpdb->prepare( ' AND comment_parent = %d', $parent );

if ( '' !== $user_id )

$where .= $wpdb->prepare( ' AND user_id = %d', $user_id );

if ( '' !== $search )

$where .= $this->get_search_sql( $search, array( 'comment_author', 'comment_author_email', 'comment_author_url', 'comment_author_IP', 'comment_content' ) );

$post_fields = array_filter( compact( array( 'post_author', 'post_name', 'post_parent', 'post_status', 'post_type') ) );

if ( ! empty( $post_fields ) ) {

$join = "JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID";

foreach( $post_fields as $field_name => $field_value )

$where .= $wpdb->prepare( " AND {$wpdb->posts}.{$field_name} = %s", $field_value );

}

if(array_key_exists('tax_query', $query_vars) && ! empty($query_vars['tax_query']))

{

$pq = new WP_Tax_Query( $query_vars['tax_query']);

$compact = $pq->get_sql($wpdb->posts, 'ID');

if(strlen($join) == 0)

{

$join = "JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID";

}

$join .= $compact['join'];

$where .= $compact['where'];

}

$pieces = array( 'fields', 'join', 'where', 'orderby', 'order', 'limits' );

$clauses = apply_filters_ref_array( 'comments_clauses', array( compact( $pieces ), &$this ) );

foreach ( $pieces as $piece )

$$piece = isset( $clauses[ $piece ] ) ? $clauses[ $piece ] : '';

$query = "SELECT $fields FROM $wpdb->comments $join WHERE $where ORDER BY $orderby $order $limits";

if ( $count )

return $wpdb->get_var( $query );

$comments = $wpdb->get_results( $query );

$comments = apply_filters_ref_array( 'the_comments', array( $comments, &$this ) );

wp_cache_add( $cache_key, $comments, 'comment' );

return $comments;

}