Hibernate version:
3.1.3

Name and version of the database you are using:
MySQL 5.0.19

HQL:
SELECT o.id FROM Release o JOIN o.shop s JOIN s.resellers r WITH r.id = :shopId WHERE o.id = :releaseId AND o.released <= :now

The generated SQL (show_sql=true):
select release0_.id as col_0_0_ from ContentItem release0_ inner join Shop shop1_ on release0_.shopId=shop1_.id inner join Reseller resellers2_ on shop1_.id=resellers2_.shopId and inner join Shop resellersh3_ on resellers2_.resellerShopId=resellersh3_.id and (resellersh3_.id=?) where release0_.type='Release' and release0_.id=? and release0_.released<=?

Somehow Hibernate adds an "and" in the join clause which causes a syntax error. Any clues on how to solve this?

Ok, I found the cause. I had an unused empty where clause in my mapping.