function icl_get_tax_children_recursive($id, $taxonomy = 'category')
{
    global $wpdb;
    $id = (array) $id;
    $children = $wpdb->get_col($wpdb->prepare("SELECT term_id FROM {$wpdb->term_taxonomy} x WHERE x.taxonomy=%s AND parent IN (" . join(',', $id) . ")", $taxonomy));
    if (!empty($children)) {
        $children = array_merge($children, icl_get_tax_children_recursive($children));
    }
    return $children;
}

//.........这里部分代码省略.........
                 $where .= " AND (iclts.status = " . ICL_TM_COMPLETE . " OR iclts.status = " . ICL_TM_DUPLICATE . ") AND iclts.needs_update = 0\n";
             }
         } elseif ($active_languages && count($active_languages) > 1) {
             if ($tstatus == 'not') {
                 $where .= " AND (";
                 $wheres = array();
                 foreach ($active_languages as $lang) {
                     if ($lang['code'] == $from_lang) {
                         continue;
                     }
                     $tbl_alias_suffix = str_replace('-', '_', $lang['code']);
                     $wheres[] = "iclts_{$tbl_alias_suffix}.status IS NULL OR iclts_{$tbl_alias_suffix}.status = " . ICL_TM_WAITING_FOR_TRANSLATOR . " OR iclts_{$tbl_alias_suffix}.needs_update = 1\n";
                 }
                 $where .= join(' OR ', $wheres) . ")";
             } elseif ($tstatus == 'need-update') {
                 $where .= " AND (";
                 $wheres = array();
                 foreach ($active_languages as $lang) {
                     if ($lang['code'] == $from_lang) {
                         continue;
                     }
                     $tbl_alias_suffix = str_replace('-', '_', $lang['code']);
                     $wheres[] = "iclts_{$tbl_alias_suffix}.needs_update = 1\n";
                 }
                 $where .= join(' OR ', $wheres) . ")";
             } elseif ($tstatus == 'in_progress') {
                 $where .= " AND (";
                 $wheres = array();
                 foreach ($active_languages as $lang) {
                     if ($lang['code'] == $from_lang) {
                         continue;
                     }
                     $tbl_alias_suffix = str_replace('-', '_', $lang['code']);
                     $wheres[] = "iclts_{$tbl_alias_suffix}.status = " . ICL_TM_IN_PROGRESS . "\n";
                 }
                 $where .= join(' OR ', $wheres) . ")";
             } elseif ($tstatus == 'complete') {
                 foreach ($active_languages as $lang) {
                     if ($lang['code'] == $from_lang) {
                         continue;
                     }
                     $tbl_alias_suffix = str_replace('-', '_', $lang['code']);
                     $where .= " AND (iclts_{$tbl_alias_suffix}.status = " . ICL_TM_COMPLETE . " OR iclts_{$tbl_alias_suffix}.status = " . ICL_TM_DUPLICATE . ") AND iclts_{$tbl_alias_suffix}.needs_update = 0\n";
                 }
             }
         }
     }
     if (isset($parent_type) && $parent_type == 'page' && $parent_id > 0) {
         if ($parent_all) {
             $children = icl_get_post_children_recursive($parent_id);
             if (!$children) {
                 $children[] = -1;
             }
             $where .= ' AND p.ID IN (' . join(',', $children) . ')';
         } else {
             $where .= ' AND p.post_parent=' . intval($parent_id);
         }
     }
     if (isset($parent_type) && $parent_type == 'category' && $parent_id > 0) {
         if ($parent_all) {
             $children = icl_get_tax_children_recursive($parent_id);
             $children[] = $parent_id;
             $join .= "  JOIN {$wpdb->term_relationships} tr ON p.ID = tr.object_id\n\t\t\t\t\t\t\tJOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category'\n\t\t\t\t\t\t\tJOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id AND tm.term_id IN(" . join(',', $children) . ")";
         } else {
             $join .= "  JOIN {$wpdb->term_relationships} tr ON p.ID = tr.object_id\n\t\t\t\t\t\t\tJOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category'\n\t\t\t\t\t\t\tJOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id AND tm.term_id = " . intval($parent_id);
         }
     }
     // ORDER
     if ($sort_by) {
         $order = " {$sort_by} ";
     } else {
         $order = " p.post_date DESC";
     }
     if ($sort_order) {
         $order .= $sort_order;
     } else {
         $order .= 'DESC';
     }
     // LIMIT
     if (!isset($_GET['paged'])) {
         $_GET['paged'] = 1;
     }
     $offset = ($_GET['paged'] - 1) * $limit_no;
     $limit = " " . $offset . ',' . $limit_no;
     $sql = "\n\t\t\tSELECT SQL_CALC_FOUND_ROWS {$select}\n\t\t\tFROM {$from}\n\t\t\t{$join}\n\t\t\tWHERE {$where}\n\t\t\tORDER BY {$order}\n\t\t\tLIMIT {$limit}\n\t\t";
     $results = $wpdb->get_results($sql);
     $count = $wpdb->get_var("SELECT FOUND_ROWS()");
     $wp_query->found_posts = $count;
     $wp_query->query_vars['posts_per_page'] = $limit_no;
     $wp_query->max_num_pages = ceil($wp_query->found_posts / $limit_no);
     // post process
     foreach ($results as $k => $v) {
         if ($v->is_translation) {
             $source_language = $wpdb->get_var($wpdb->prepare("SELECT language_code FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL", $v->trid));
             $_tmp = 'status_' . $source_language;
             $v->{$_tmp} = ICL_TM_COMPLETE;
         }
     }
     return $results;
 }