我正在尝试使用Doctrine 2实现复杂的SQL查询.
但是,我的SQL查询有子选择.我认为这是’问题,但我无法实现解决这个问题的方法.
SELECT
x.year, x.month, y.total
FROM
(SELECT
YEAR(a.date) year, MONTH(a.date) month, count(*) number
FROM
Acessos a
GROUP BY
YEAR(a.date), MONTH(a.date)) x
INNER JOIN
(SELECT
MAX(Z.number) total
FROM
(SELECT
COUNT(a.id) number
FROM
Acessos a
GROUP BY
YEAR(a.date), MONTH(a.date)) z) y ON x.number = y.total LIMIT 1
当我把这个查询运行到trhu代码时,我得到一个QueryException.
Fatal error: Uncaught exception 'Doctrine\ORM\Query\QueryException'
with message 'SELECT x.messelecionado, x.anoselecionado, y.total from (select
month(a.data) messelecionado, year(a.data) anoselecionado, count(*) numero from
Acesso a group by month(a.data), year(a.data)) x inner join (select max(z.numero)
total from (select count(a.id) numero from Acesso a group by month(a.data),
year(a.data)) z) y on x.numero = y.total limit 1' in
C:\xampp\htdocs\patclin\app\Doctrine\ORM\Query\QueryException.php:39
Stack trace:
#0 C:\xampp\htdocs\patclin\app\Doctrine\ORM\Query\Parser.php(429):
Doctrine\ORM\Query\QueryException::dqlError('SELECT x.messel...')
#1 C:\xampp\htdocs\patclin\app\Doctrine\ORM\Query\Parser.php(854):
Doctrine\ORM\Query\Parser->semanticalError('Class '(' is no...', Array)
#2 C:\xampp\htdocs\patclin\app\Doctrine\ORM\Query\Parser.php(1529):
Doctrine\ORM\Query\Parser->AbstractSchemaName()
#3 C:\xampp\htdocs\patclin\app\Doctrine\ORM\Query\Parser.php(1426):
Doctrine\ORM\Query\Parser->RangeVariableDeclaration()
#4 C:\x in C:\xampp\htdocs\patclin\app\Doctrine\ORM\Query\QueryException.php
on line 49
谁知道我该怎么办?
谢谢!!!