protected function loadPage()
 {
     $table = new PhabricatorPaste();
     $conn_r = $table->establishConnection('r');
     $data = queryfx_all($conn_r, 'SELECT paste.* FROM %T paste %Q %Q %Q', $table->getTableName(), $this->buildWhereClause($conn_r), $this->buildOrderClause($conn_r), $this->buildLimitClause($conn_r));
     $pastes = $table->loadAllFromArray($data);
     return $pastes;
 }
 public function loadPage()
 {
     $table = new PhabricatorPaste();
     $conn_r = $table->establishConnection('r');
     $data = queryfx_all($conn_r, 'SELECT paste.* FROM %T paste %Q %Q %Q', $table->getTableName(), $this->buildWhereClause($conn_r), $this->buildOrderClause($conn_r), $this->buildLimitClause($conn_r));
     $pastes = $table->loadAllFromArray($data);
     if ($pastes && $this->needContent) {
         $file_phids = mpull($pastes, 'getFilePHID');
         $files = id(new PhabricatorFile())->loadAllWhere('phid IN (%Ls)', $file_phids);
         $files = mpull($files, null, 'getPHID');
         foreach ($pastes as $paste) {
             $file = idx($files, $paste->getFilePHID());
             if ($file) {
                 $paste->attachContent($file->loadFileData());
             } else {
                 $paste->attachContent('');
             }
         }
     }
     return $this->processResults($pastes);
 }