php - MySQL - 在 NOT EXISTS 中使用已定义的类

Question

我有一个查询来选择所有未投票的提案ProposalBundle:Proposal\Vote。 v.decision 中可能存在“not_voted”值，也可能不存在。这就是我使用 NOT EXIST 的原因。

SELECT p 
FROM ProProposalBundle:Proposal p 
INNER JOIN ProProposalBundle:Proposal\Vote v 
    WITH v.proposal = p 
        AND (v.decision = 'not_voted' OR NOT EXISTS (SELECT v FROM v WHERE v.user = {$user})) 
WHERE p.community = {$community}

但它返回一个错误:

[Semantical Error] line 0, col 181 near 'v WHERE v.user': Error: Class 'v' is not defined. 

它与NOT EXISTS部分相关，其中v理论上是之前定义的。我也尝试过这样做:

... NOT EXISTS (SELECT v FROM ProProposalBundle:Proposal\Vote v WHERE v.user = {$user}))

但现在我得到:

[Semantical Error] line 0, col 220 near 'v WHERE v.user': Error: 'v' is already defined. 

知道我做错了什么吗？

Answer 1

尝试

NOT EXISTS (SELECT * FROM ProProposalBundle:Proposal\Vote v WHERE v.user = {$user}))