class LatestRevision

class LatestRevision extends FilterPluginBase implements ContainerFactoryPluginInterface {
    
    /**
     * Entity Type Manager service.
     *
     * @var \Drupal\Core\Entity\EntityTypeManagerInterface
     */
    protected $entityTypeManager;
    
    /**
     * Views Handler Plugin Manager.
     *
     * @var \Drupal\views\Plugin\ViewsHandlerManager
     */
    protected $joinHandler;
    
    /**
     * Constructs a new LatestRevision.
     *
     * @param array $configuration
     *   A configuration array containing information about the plugin instance.
     * @param string $plugin_id
     *   The plugin ID for the plugin instance.
     * @param mixed $plugin_definition
     *   The plugin implementation definition.
     * @param \Drupal\Core\Entity\EntityTypeManagerInterface $entity_type_manager
     *   Entity Type Manager Service.
     * @param \Drupal\views\Plugin\ViewsHandlerManager $join_handler
     *   Views Handler Plugin Manager.
     */
    public function __construct(array $configuration, $plugin_id, $plugin_definition, EntityTypeManagerInterface $entity_type_manager, ViewsHandlerManager $join_handler) {
        parent::__construct($configuration, $plugin_id, $plugin_definition);
        $this->entityTypeManager = $entity_type_manager;
        $this->joinHandler = $join_handler;
    }
    
    /**
     * {@inheritdoc}
     */
    public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition) {
        return new static($configuration, $plugin_id, $plugin_definition, $container->get('entity_type.manager'), $container->get('plugin.manager.views.join'));
    }
    
    /**
     * {@inheritdoc}
     */
    public function adminSummary() {
    }
    
    /**
     * {@inheritdoc}
     */
    protected function operatorForm(&$form, FormStateInterface $form_state) {
    }
    
    /**
     * {@inheritdoc}
     */
    public function canExpose() {
        return FALSE;
    }
    
    /**
     * {@inheritdoc}
     */
    public function query() {
        
        /** @var \Drupal\views\Plugin\views\query\Sql $query */
        $query = $this->query;
        $query_base_table = $this->relationship ?: $this->view->storage
            ->get('base_table');
        $entity_type = $this->entityTypeManager
            ->getDefinition($this->getEntityType());
        $keys = $entity_type->getKeys();
        $subquery = $query->getConnection()
            ->select($query_base_table, 'base_table');
        $subquery->addExpression("MAX(base_table.{$keys['revision']})", $keys['revision']);
        $subquery->groupBy("base_table.{$keys['id']}");
        $query->addWhere($this->options['group'], "{$query_base_table}.{$keys['revision']}", $subquery, 'IN');
    }

}