<?php


  /**
   * {@inheritdoc}
   */
  public function query() {
    // get all repeater headlines as our base list of paragraphs.
    $query = $this->select('postmeta', 'pm');
    $query->innerJoin('posts', 'p', 'pm.post_id = p.id');
    $query->fields('pm', ['meta_id', 'post_id', 'meta_key', 'meta_value']);
    $query->addField('pm', 'meta_value', 'headline');
    $query
      ->condition('p.post_type', 'post');
    $query->groupBy('pm.post_id');
    $query->groupBy('pm.meta_key');
    $conditions = new Condition('AND');
    $meta_key = $query->escapeLike('weekly_news_repeater_');
    $meta_key_suffix = $query->escapeLike('_headline');
    $conditions->condition('pm.meta_key', $meta_key . '%' . $meta_key_suffix, 'LIKE');
    $query->condition($conditions);

    return $query;
  }