请教一下大神们,这个where条件查询写成HQL怎么写的?
SELECT sysRoomType.typeName, sysRoomOrders.room_id, sysRoomOrders.endDate, sysRoomOrders.starDate, sysRoomType.id
FROM sysRoomType INNER JOIN
sysRoom ON sysRoomType.id = sysRoom.roomType_id INNER JOIN
sysRoomOrders ON sysRoom.id = sysRoomOrders.room_id
where sysRoomOrders.starDate between 145745280 and 14571936001 and sysRoomType.id =1
or sysRoomOrders.endDate between 145745280 and 14571936001 and sysRoomType.id =1