String sql = "select count(orders.productid) from Orders as orders where orders.ordernumber in(select orders.ordernumber from orders where orders.productid=:productid );

'parse error near where' yet I dont see how I'm wrong

Looks like no class alias in the HQL sub-select.

Yeah, I realized some minutes ago.
Another problem, how do I order by 'count()',
I tried to make like postgres 'order by count', but
he doest accept this, the manual doest mention this
any clue?