StatisticsLastUpdated.php

<?php

namespace Drupal\comment\Plugin\views\filter;

use Drupal\views\Attribute\ViewsFilter;
use Drupal\views\Plugin\views\filter\Date;

/**
 * Filter handler for the newer of last comment / node updated.
 *
 * @ingroup views_filter_handlers
 */
class StatisticsLastUpdated extends Date {
    
    /**
     * The node table.
     */
    // phpcs:ignore Drupal.NamingConventions.ValidVariableName.LowerCamelName
    protected ?string $node_table;
    public function query() {
        $this->ensureMyTable();
        $this->node_table = $this->query
            ->ensureTable('node', $this->relationship);
        $field = "GREATEST(" . $this->node_table . ".changed, " . $this->tableAlias . ".last_comment_timestamp)";
        $info = $this->operators();
        if (!empty($info[$this->operator]['method'])) {
            $this->{$info[$this->operator]['method']}($field);
        }
    }

}