fork download
copy 
  1. //Было
  2. return $this->createQueryBuilder('test')
  3.     ->orderBy('test.successAttempts+test.failedAttempts', 'DESC')
  4.     ->setMaxResults(5)
  5.     ->getQuery()
  6.     ->getResult();
  7.  
  8. //Стало
  9. return $this->_em->createQuery('
  10.     SELECT t FROM ' . Test::class . ' t
  11.     ORDER BY t.successAttempts+t.failedAttempts DESC
  12. ')
  13. ->setMaxResults(5)
  14. ->execute();
Success #stdin #stdout 0.02s 23384KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
//Было
return $this->createQueryBuilder('test')
    ->orderBy('test.successAttempts+test.failedAttempts', 'DESC')
    ->setMaxResults(5)
    ->getQuery()
    ->getResult();

//Стало
return $this->_em->createQuery('
    SELECT t FROM ' . Test::class . ' t
    ORDER BY t.successAttempts+t.failedAttempts DESC
')
->setMaxResults(5)
->execute();
https://ideone.com/6Wqs9R
language:
PHP (php 7.3.5)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!