Club Drupal

    $query->join('taxonomy_term_hierarchy', 'h', 'h.parent = t.tid');

    $query->addField('t', 'tid');

    $query->condition('h.tid', $tid);

    $query->orderBy('t.weight');

    $query->orderBy('t.name');

    $tids = $query->execute()->fetchCol();

    if ($vid) {

      $query->condition('t.vid', $vid);

    }

    $query->orderBy('t.weight');

    $query->orderBy('t.name');

    $tids = $query->execute()->fetchCol();

    $query->join('taxonomy_term_hierarchy', 'h', 'h.tid = t.tid');

    $result = $query

      ->addTag('translatable')

      ->fields('t')

      ->fields('h', array('parent'))

      ->condition('t.vid', $vid)

  protected function buildQuery($ids, $conditions = array(), $revision_id = FALSE) {

    $query = parent::buildQuery($ids, $conditions, $revision_id);

    $query->addTag('translatable');

    // When name is passed as a condition use LIKE.

    if (isset($conditions['name'])) {

      $query_conditions = &$query->conditions();