Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM vocabulary.word
- WHERE movie_id = (select movie_id from vocabulary.word order by id desc LIMIT 1)
- AND season = (select season from vocabulary.word order by id desc LIMIT 1)
- AND episode = (select episode from vocabulary.word order by id desc LIMIT 1)
- $query = $this->createQueryBuilder('w1')
- ->select([
- 'w1.movie',
- 'w1.season',
- 'w1.episode'
- ])
- ->orderBy('w1.id', 'DESC')
- ->setMaxResults(1)
- ;
- return $this->createQueryBuilder('w')
- ->select([
- 'w.name as word',
- 'w.translation as translation',
- 'm.name as movie',
- 'w.season as season',
- 'w.episode as episode',
- ])
- ->leftJoin('w.movie', 'm')
- ->where($query->expr()->eq('m.movie', $query->getDQL()))
- ->andWhere($query->expr()->eq('w.season', $query->getDQL()))
- ->where($query->expr()->eq('w.episode', $query->getDQL()))
- ->orderBy('RAND()')
- ->setMaxResults($limit)
- ->getQuery()
- ->getResult();
Add Comment
Please, Sign In to add comment