Results

    if (!isset($this->latestRevisionIds[$entity_id][LanguageInterface::LANGCODE_DEFAULT])) {
      $result = $this->entityTypeManager()->getStorage($entity_type->id())->getQuery()
        ->latestRevision()
        ->condition($entity_type->getKey('id'), $entity_id)
        ->accessCheck(FALSE)
        ->addTag('workspace_sensitive')
        ->execute();

      $this->latestRevisionIds[$entity_id][LanguageInterface::LANGCODE_DEFAULT] = key($result);

    // If the request is for the latest revision, toggle it on entity query.
    if ($request->get(ResourceVersionRouteEnhancer::WORKING_COPIES_REQUESTED, FALSE)) {
      $query->latestRevision();
    }

    try {
      $results = $this->executeQueryInRenderContext(
        $query,
        $query_cacheability

            if($revisionable) {
              $entities = \Drupal::entityTypeManager()->getStorage($entity_type)->getQuery()
          ->latestRevision()
          ->condition($value, $tid, '=')->range(0,$iterate_limit)->execute();
           }else{
            $entities = \Drupal::entityTypeManager()->getStorage($entity_type)->getQuery()->condition($value, $tid, '=')->range(0,$iterate_limit)->execute();
           }
          }else {
            continue 2;

            ->condition('field_package_state', 'active', '=')
            ->condition('status', Node::PUBLISHED)
            ->latestRevision()
            ->range(0, 1)
            ->execute();

          if (isset($harv_pkg)) {
            $pkg_array = new ArrayObject($harv_pkg);
            $pkg_itterator = $pkg_array->GetIterator();

    if ($this->moderationInfo) {
      $query->latestRevision();
    }

    // Only add the pager if a limit is specified.
    if ($this->limit) {
      $query->pager($this->limit);
    }

function entity_translation_unified_form_etuf_latest_revision($id, &$vid, $lang, $entity_type = 'node') {
  $query = \Drupal::entityTypeManager()->getStorage($entity_type)->getQuery();
  $query->latestRevision()
    ->accessCheck(TRUE);
  if ($entity_type == 'node') {
    $query->condition('nid', $id, '=');
  }
  if ($entity_type == 'taxonomy_term') {
    $query->condition('tid', $id, '=');

                ->accessCheck()
                ->condition($idKey, $_entity->entity_id->value)
                ->latestRevision()
                ->execute();
            }

            if ($revision) {
              $rid = key($revision);
              $entity = $storage->loadRevision($rid);

    elseif ($mode === 'LATEST') {
      // Mark the query to only include latest revision and sort by revision id.
      $query->latestRevision();
      $query->addTag('revisions');
    }

    return $query;
  }

      // Only get default revisions to avoid processing previous revisions.
      if ($entityType->isRevisionable()) {
        $query->latestRevision();
      }

      // For paragraph entities, filter to exclude orphaned revisions.
      if ($entity_type_id === 'paragraph') {
        // Only include paragraphs that have a parent entity reference.
        $query->exists('parent_id');

    // Only go back in time as far as the last successful cron.
    $ids = $storage->getQuery()
        ->latestRevision()
        ->accessCheck(FALSE)
        ->condition('scheduled_transition_date.value', $now, '<=')
        ->condition('scheduled_transition_date.value', $time_ago_in_drupal_datetime_for_query, '>=')
        ->execute();

    foreach (array_keys($ids) as $revision_id) {

    $entity_type = $entity->getEntityTypeId();
    $query = \Drupal::entityTypeManager()->getStorage($entity_type)->getQuery();
    $query->latestRevision();
    $query->condition($entity->getEntityType()->getKey('id'), $id, '=');

    // We must bypass access checks here: this runs in shutdown context and
    // must see draft revisions even if the ambient user cannot.
    $query->accessCheck(FALSE);
    $latestRevisionResult = $query->execute();

      $latestRevisionResult = \Drupal::entityTypeManager()->getStorage($entity->getEntityType()->id())->getQuery()
        ->latestRevision()
        ->condition($entity->getEntityType()->getKey('id'), $entityId, '=')
        ->accessCheck(TRUE)
        ->execute();
      if (count($latestRevisionResult)) {
        $node_revision_id = key($latestRevisionResult);
        if ($node_revision_id == $vid) {

    $latestRevisionResult = \Drupal::entityTypeManager()->getStorage('node')->getQuery()
      ->accessCheck(FALSE)
      ->latestRevision()
      ->condition('nid', $nid, '=')
      ->execute();
    if (count($latestRevisionResult)) {
      $node_revision_id = key($latestRevisionResult);
      if ($node_revision_id == $vid) {
        // There is no pending revision, the current revision is the latest.

            if($revisionable) {
              $entities = \Drupal::entityTypeManager()->getStorage($entity_type)->getQuery()
          ->latestRevision()
          ->condition($value, $tid, '=')->range(0,$iterate_limit)->execute();
           }else{
            $entities = \Drupal::entityTypeManager()->getStorage($entity_type)->getQuery()->condition($value, $tid, '=')->range(0,$iterate_limit)->execute();
           }
          }else {
            continue 2;

    $query->condition($and1);
    $nids = $query->accessCheck(FALSE)
      ->latestRevision()->execute();
    $entities = [];
    $items_count = 0;
    foreach ($nids as $nid) {
      $entity = \Drupal::entityTypeManager()->getStorage('node')->load($nid);
      $moderation_state = 'published';
      if (!$entity->isPublished()) {

    $query->condition($and1);
    $nids = $query->accessCheck(FALSE)
      ->latestRevision()->execute();
    $entities = [];
    $items_count = 0;
    foreach ($nids as $nid) {
      $entity = \Drupal::entityTypeManager()->getStorage('node')->load($nid);
      $moderation_state = 'published';
      if (!$entity->isPublished()) {

    $query->condition($and1);
    $nids = $query->accessCheck(FALSE)
      ->latestRevision()->execute();
    if (!empty($nids)) {
      return TRUE;
    }
    return FALSE;
  }

    $qeryarray = \Drupal::entityTypeManager()->getStorage('node')->getQuery()
    ->accessCheck(FALSE)
    ->latestRevision()
    ->condition('nid' , $entity_id, '=')
    ->execute();
    $latestver = key($qeryarray);
    $db_nodeenity = NULL;
    if (isset($latestver)) {
      $db_nodeenity = \Drupal::entityTypeManager()

    $latestRevisionResult = \Drupal::entityTypeManager()->getStorage('node')->getQuery()
      ->accessCheck(FALSE)
      ->latestRevision()
      ->condition('nid', $nid, '=')
      ->execute();
    if (count($latestRevisionResult)) {
      $node_revision_id = key($latestRevisionResult);
      if ($node_revision_id == $vid) {
        // There is no pending revision, the current revision is the latest.

          $query->condition($scheduledField, NULL, 'IS NOT NULL');
          $query->accessCheck(FALSE);
          $query->latestRevision();
          $entities = $query->execute();
          foreach ($entities as $entityRevision => $entityId) {
            $storage = $this->entityTypeManager->getStorage($entityType);
            /** @var \Drupal\Core\Entity\RevisionableStorageInterface $storage */
            $revision = $storage->loadRevision($entityRevision);
            $this->updateEntityField($revision, $scheduledField);

        // latest revision. This is important for moderated entities.
        if ($plugin->entityTypeObject()->isRevisionable()) {
          $query->latestRevision();
        }
        // Add tags to let other modules alter the query.
        $query->addTag('scheduler');
        $query->addTag('scheduler_publish');
        $query->addTag('scheduler_' . $entityTypeId . '_publish');
        $ids = $query->execute();

        // latest revision. This is important for moderated entities.
        if ($plugin->entityTypeObject()->isRevisionable()) {
          $query->latestRevision();
        }
        // Add tags to let other modules alter the query.
        $query->addTag('scheduler');
        $query->addTag('scheduler_unpublish');
        $query->addTag('scheduler_' . $entityTypeId . '_unpublish');
        $ids = $query->execute();

      ->condition('moderation_state', 'draft')
      ->condition('moderation_state', 'scheduled_publish');
    $q->latestRevision();
    $q->accessCheck(TRUE);
    $q->condition($or_cond);
    $draft_ids = $q->execute();

    if (!empty($draft_ids)) {
      return array_flip($draft_ids);

    $query = \Drupal::entityQuery('media');
    $query->accessCheck(TRUE);
    $query->latestRevision();
    $exclude_media_ids = $query->execute();
    return $exclude_media_ids;
  }

  /**
   * List file name and update time for a path.