forum-1.x-dev/src/Plugin/Block/NewTopicsBlock.php

<?php

namespace Drupal\forum\Plugin\Block;

use Drupal\Core\Block\Attribute\Block;
use Drupal\Core\Database\Database;
use Drupal\Core\StringTranslation\TranslatableMarkup;

/**
 * Provides a 'New forum topics' block.
 */
#[Block(
  id: "forum_new_block",
  admin_label: new TranslatableMarkup("New forum topics"),
  category: new TranslatableMarkup("Lists (Views)")
)]
class NewTopicsBlock extends ForumBlockBase {

  /**
   * {@inheritdoc}
   */
  protected function buildForumQuery() {
    return Database::getConnection()->select('forum_index', 'f')
      ->fields('f')
      ->addTag('node_access')
      ->addMetaData('base_table', 'forum_index')
      ->orderBy('f.created', 'DESC')
      ->range(0, $this->configuration['block_count']);
  }

}