diff --git a/core/modules/tracker/lib/Drupal/tracker/Controller/TrackerController.php b/core/modules/tracker/lib/Drupal/tracker/Controller/TrackerController.php index 5c92986..9ee381d 100644 --- a/core/modules/tracker/lib/Drupal/tracker/Controller/TrackerController.php +++ b/core/modules/tracker/lib/Drupal/tracker/Controller/TrackerController.php @@ -100,13 +100,13 @@ public function trackerPage($account = NULL, $set_title = FALSE) { ->getStorageController('node') ->load($nids); // Now, get the data and put into the placeholder array. - $result = $this->database->select('node', 'n', array('target' => 'slave')) - ->addField('n', 'nid') - ->addField('l', 'comment_count') - ->join('node_comment_statistics', 'l', 'n.nid = l.nid') - ->join('users', 'u', 'n.uid = u.uid') - ->condition('n.nid', $nids, 'IN') - ->fetchAllKeyed(); + $select = $this->database->select('node', 'n', array('target' => 'slave')); + $select->join('node_comment_statistics', 'l', 'n.nid = l.nid'); + $select->join('users', 'u', 'n.uid = u.uid'); + $select->addField('n', 'nid'); + $select->addField('l', 'comment_count'); + $select->condition('n.nid', $nids, 'IN'); + $result = $select->execute()->fetchAllKeyed(); foreach ($result as $nid => $comment_count) { $nodes[$nid]->last_activity = $tracker_data[$nid]->changed; $nodes[$nid]->comment_count = $comment_count;