Guest User

Untitled

a guest
Nov 21st, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. SELECT * FROM vocabulary.word
  2. WHERE movie_id = (select movie_id from vocabulary.word order by id desc LIMIT 1)
  3. AND season = (select season from vocabulary.word order by id desc LIMIT 1)
  4. AND episode = (select episode from vocabulary.word order by id desc LIMIT 1)
  5.  
  6. $query = $this->createQueryBuilder('w1')
  7. ->select([
  8. 'w1.movie',
  9. 'w1.season',
  10. 'w1.episode'
  11. ])
  12. ->orderBy('w1.id', 'DESC')
  13. ->setMaxResults(1)
  14. ;
  15.  
  16. return $this->createQueryBuilder('w')
  17. ->select([
  18. 'w.name as word',
  19. 'w.translation as translation',
  20. 'm.name as movie',
  21. 'w.season as season',
  22. 'w.episode as episode',
  23. ])
  24. ->leftJoin('w.movie', 'm')
  25. ->where($query->expr()->eq('m.movie', $query->getDQL()))
  26. ->andWhere($query->expr()->eq('w.season', $query->getDQL()))
  27. ->where($query->expr()->eq('w.episode', $query->getDQL()))
  28. ->orderBy('RAND()')
  29. ->setMaxResults($limit)
  30. ->getQuery()
  31. ->getResult();
Add Comment
Please, Sign In to add comment