Arbitrary JOIN problem

[birko]

Hello. I created a query using Doctrine2 (2.3 and above version) Arbitrary join syntax

$productQueryBuilder->leftJoin("NeonusNwsProductPriceBundle:Price", "pp", \Doctrine\ORM\Query\Expr\Join::WITH, 'p.id=pp.product');

and I got an error with this text
"Cannot count query which selects two FROM components, cannot make distinction"

Can you please help me how to make a workaround for this?
I need this kind of join to sort my Product table according Price table that has an unidirectional ManyToOne reference to product, (Because of my modular architecture) therefor I cannot use normal leftjoin.

Thank you for your reply and suggestions

[adrienrusso]

+1

[birko]

I am solving this issue in this PR doctrine/orm#1092 I figured out it is the doctrine2 count query walker that needed a fix