core/modules/aggregator/aggregator.pages.inc:    $result = db_query('SELECT f.title, f.url FROM {aggregator_feed} f LEFT JOIN {aggregator_category_feed} c on f.fid = c.fid WHERE c.cid = :cid ORDER BY title', array(':cid' => $cid));
core/modules/aggregator/lib/Drupal/aggregator/ItemStorageController.php:      $item->categories = db_query('SELECT c.title, c.cid FROM {aggregator_category_item} ci LEFT JOIN {aggregator_category} c ON ci.cid = c.cid WHERE ci.iid = :iid ORDER BY c.title', array(':iid' => $item->id()))->fetchAll();
core/modules/aggregator/lib/Drupal/aggregator/ItemStorageController.php:    $result = $this->database->query('SELECT cid FROM {aggregator_category_feed} WHERE fid = :fid', array(':fid' => $item->fid->value));
core/modules/aggregator/lib/Drupal/aggregator/CategoryStorageController.php:      $this->categories[$cid] = $this->database->query("SELECT * FROM {aggregator_category} WHERE cid = :cid", array(':cid' => $cid))->fetchObject();
core/modules/aggregator/lib/Drupal/aggregator/Plugin/Derivative/AggregatorCategoryBlock.php:    $result = $this->connection->query('SELECT cid, title FROM {aggregator_category} ORDER BY title WHERE cid = :cid', array(':cid' => $derivative_id))->fetchObject();
core/modules/aggregator/lib/Drupal/aggregator/Plugin/Derivative/AggregatorCategoryBlock.php:    $result = $this->connection->query('SELECT cid, title FROM {aggregator_category} ORDER BY title');
core/modules/aggregator/lib/Drupal/aggregator/Plugin/Block/AggregatorCategoryBlock.php:    if ($category = db_query('SELECT cid, title, block FROM {aggregator_category} WHERE cid = :cid', array(':cid' => $id))->fetchObject()) {
core/modules/aggregator/lib/Drupal/aggregator/Plugin/views/argument/CategoryCid.php:    $titles = $this->database->query("SELECT title FROM {aggregator_category} where cid IN (:cid)", array(':cid' => $this->value))->fetchCol();
core/modules/aggregator/lib/Drupal/aggregator/Plugin/views/filter/CategoryCid.php:    $this->value_options = $this->database->query('SELECT cid, title FROM {aggregator_category} ORDER BY title')->fetchAllKeyed();
core/modules/aggregator/lib/Drupal/aggregator/FeedFormController.php:    $categories = db_query('SELECT c.cid, c.title FROM {aggregator_category} c ORDER BY title');
core/modules/aggregator/lib/Drupal/aggregator/Controller/AggregatorController.php:    $result = $this->database->query('SELECT c.cid, c.title, COUNT(ci.iid) as items FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid GROUP BY c.cid, c.title ORDER BY title');
core/modules/aggregator/lib/Drupal/aggregator/Controller/AggregatorController.php:    $result = $this->database->query('SELECT c.cid, c.title, c.description FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid LEFT JOIN {aggregator_item} i ON ci.iid = i.iid GROUP BY c.cid, c.title, c.description');
core/modules/aggregator/lib/Drupal/aggregator/FeedStorageController.php:      $feed->categories = $this->database->query('SELECT c.cid, c.title FROM {aggregator_category} c JOIN {aggregator_category_feed} f ON c.cid = f.cid AND f.fid = :fid ORDER BY title', array(':fid' => $feed->id()))->fetchAllKeyed();
core/modules/aggregator/lib/Drupal/aggregator/Tests/AggregatorTestBase.php:    $result = db_query('SELECT cid FROM {aggregator_category_feed} WHERE fid = :fid', array(':fid' => $feed->id()));
core/modules/aggregator/lib/Drupal/aggregator/Tests/AggregatorTestBase.php:    $result = db_query('SELECT * FROM {aggregator_category}');
core/modules/aggregator/lib/Drupal/aggregator/Tests/CategorizeFeedItemTest.php:    $category = db_query("SELECT * FROM {aggregator_category} WHERE title = :title", array(':title' => $edit['title']))->fetch();
core/modules/aggregator/lib/Drupal/aggregator/Tests/ImportOpmlTest.php:    $feeds_from_db = db_query("SELECT f.title, f.url, f.refresh, cf.cid FROM {aggregator_feed} f LEFT JOIN {aggregator_category_feed} cf ON f.fid = cf.fid");
core/modules/aggregator/lib/Drupal/aggregator/Form/AggregatorCategorizeFormBase.php:        $categories_result = $this->database->query('SELECT c.cid, c.title, ci.iid FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid AND ci.iid = :iid', array(':iid' => $iid));
core/modules/aggregator/lib/Drupal/aggregator/Form/OpmlFeedAdd.php:    $options = array_map('check_plain', $this->database->query("SELECT cid, title FROM {aggregator_category} ORDER BY title")->fetchAllKeyed());