在我的Java项目中,我需要执行一个HQL查询。
以下是我的HQL查询:
这个计数总是会产生一个"1"的结果,然而,如果我删除查询的最后一行,它会返回一个正确的结果,但我需要根据上面的条件限制我的结果。请问有人能帮忙吗?
以下是我的HQL查询:
select count(distinct n.id)" +
" FROM Neighborhood n, NeighborhoodMeta meta, NeighborhoodAffordability aff, AirbnbProperty as ap" +
" WHERE n.id = meta.id AND n.id = aff.id AND n.id = ap.neighborhood AND aff.singleHomeValue!=null" +
" AND (latitude >=:minLat AND latitude <=:maxLat)" +
" AND (longitude >=:minLong " + (meridian180WithinDistance ? "OR" : "AND") + " longitude <=:maxLong) AND " +
"acos(sin(:locationLatitude) * sin(radians(latitude)) + cos(:locationLatitude) * cos(radians(latitude)) * cos(radians(longitude) -:locationLongitude)) <=:R " +
"GROUP BY ap.neighborhood having count(ap.id) > 19
这个计数总是会产生一个"1"的结果,然而,如果我删除查询的最后一行,它会返回一个正确的结果,但我需要根据上面的条件限制我的结果。请问有人能帮忙吗?