select this_.id as id40_5_, this_.associatedGisFeature_id as associat2_40_5_, gisfeature1_.id as id34_0_, gisfeature1_.parentEntity_id as parentE14_34_0_, gisfeature1_.population as population34_0_, gisfeature1_.featureId as featureId34_0_, gisfeature1_.featureSource as featureS4_34_0_, gisfeature1_.featureClass as featureC5_34_0_, gisfeature1_.featureCode as featureC6_34_0_, gisfeature1_.asciiName as asciiName34_0_, gisfeature1_.elevation as elevation34_0_, gisfeature1_.gtopo30AverageElevation as gtopo9_34_0_, gisfeature1_.modificationDate as modific10_34_0_, gisfeature1_.name as name34_0_, gisfeature1_.location as location34_0_, gisfeature1_.timeZone as timeZone34_0_, abstractad4_.id as id36_1_, abstractad4_.parentEntity_id as parentEn2_36_1_, abstractad4_.associatedGisFeature_id as associat3_36_1_, abstractad4_1_.iso3166Alpha3Code as iso2_37_1_, abstractad4_1_.fipsCode as fipsCode37_1_, abstractad4_1_.iso3166Alpha2Code as iso4_37_1_, abstractad4_1_.iso3166NumericCode as iso5_37_1_, abstractad4_1_.boundingBoxEast as bounding6_37_1_, abstractad4_1_.boundingBoxNorth as bounding7_37_1_, abstractad4_1_.boundingBoxSouth as bounding8_37_1_, abstractad4_1_.boundingBoxWest as bounding9_37_1_, abstractad4_1_.area as area37_1_, abstractad4_1_.continent_id as continent18_37_1_, abstractad4_1_.population as population37_1_, abstractad4_1_.topLevelDomain as topLeve12_37_1_, abstractad4_1_.phonePrefix as phonePr13_37_1_, abstractad4_1_.postalCodeMask as postalC14_37_1_, abstractad4_1_.equivalentFipsCode as equival15_37_1_, abstractad4_1_.name as name37_1_, abstractad4_1_.currencyCode as currenc17_37_1_, abstractad4_2_.asciiName as asciiName39_1_, abstractad4_2_.name as name39_1_, abstractad4_2_.code as code39_1_, case when abstractad4_1_.id is not null then 1 when abstractad4_2_.id is not null then 2 when abstractad4_.id is not null then 0 end as clazz_1_, abstractad5_.id as id36_2_, abstractad5_.parentEntity_id as parentEn2_36_2_, abstractad5_.associatedGisFeature_id as associat3_36_2_, abstractad5_1_.iso3166Alpha3Code as iso2_37_2_, abstractad5_1_.fipsCode as fipsCode37_2_, abstractad5_1_.iso3166Alpha2Code as iso4_37_2_, abstractad5_1_.iso3166NumericCode as iso5_37_2_, abstractad5_1_.boundingBoxEast as bounding6_37_2_, abstractad5_1_.boundingBoxNorth as bounding7_37_2_, abstractad5_1_.boundingBoxSouth as bounding8_37_2_, abstractad5_1_.boundingBoxWest as bounding9_37_2_, abstractad5_1_.area as area37_2_, abstractad5_1_.continent_id as continent18_37_2_, abstractad5_1_.population as population37_2_, abstractad5_1_.topLevelDomain as topLeve12_37_2_, abstractad5_1_.phonePrefix as phonePr13_37_2_, abstractad5_1_.postalCodeMask as postalC14_37_2_, abstractad5_1_.equivalentFipsCode as equival15_37_2_, abstractad5_1_.name as name37_2_, abstractad5_1_.currencyCode as currenc17_37_2_, abstractad5_2_.asciiName as asciiName39_2_, abstractad5_2_.name as name39_2_, abstractad5_2_.code as code39_2_, case when abstractad5_1_.id is not null then 1 when abstractad5_2_.id is not null then 2 when abstractad5_.id is not null then 0 end as clazz_2_, gisfeature6_.id as id34_3_, gisfeature6_.parentEntity_id as parentE14_34_3_, gisfeature6_.population as population34_3_, gisfeature6_.featureId as featureId34_3_, gisfeature6_.featureSource as featureS4_34_3_, gisfeature6_.featureClass as featureC5_34_3_, gisfeature6_.featureCode as featureC6_34_3_, gisfeature6_.asciiName as asciiName34_3_, gisfeature6_.elevation as elevation34_3_, gisfeature6_.gtopo30AverageElevation as gtopo9_34_3_, gisfeature6_.modificationDate as modific10_34_3_, gisfeature6_.name as name34_3_, gisfeature6_.location as location34_3_, gisfeature6_.timeZone as timeZone34_3_, continent7_.id as id35_4_, continent7_.geonamesCode as geonames2_35_4_, continent7_.geonamesName as geonames3_35_4_ from City this_ inner join GisFeature gisfeature1_ on this_.associatedGisFeature_id=gisfeature1_.id left outer join AbstractAdministrativeEntity abstractad4_ on gisfeature1_.parentEntity_id=abstractad4_.id left outer join Country abstractad4_1_ on abstractad4_.id=abstractad4_1_.id left outer join AdministrativeDivision abstractad4_2_ on abstractad4_.id=abstractad4_2_.id left outer join AbstractAdministrativeEntity abstractad5_ on abstractad4_.parentEntity_id=abstractad5_.id left outer join Country abstractad5_1_ on abstractad5_.id=abstractad5_1_.id left outer join AdministrativeDivision abstractad5_2_ on abstractad5_.id=abstractad5_2_.id left outer join GisFeature gisfeature6_ on abstractad5_.associatedGisFeature_id=gisfeature6_.id left outer join Continent continent7_ on abstractad5_1_.continent_id=continent7_.id where location && setSRID(cast ('BOX3D(-118.75666159581651 33.60255976167443,-117.72889840418348 34.50188023832557)'as box3d), 4326) AND distance_sphere(location, GeomFromText('POINT(-118.24278 34.05222)',4326)) <=  ? 
Hibernate: select this_.id as id40_5_, this_.associatedGisFeature_id as associat2_40_5_, gisfeature1_.id as id34_0_, gisfeature1_.parentEntity_id as parentE14_34_0_, gisfeature1_.population as population34_0_, gisfeature1_.featureId as featureId34_0_, gisfeature1_.featureSource as featureS4_34_0_, gisfeature1_.featureClass as featureC5_34_0_, gisfeature1_.featureCode as featureC6_34_0_, gisfeature1_.asciiName as asciiName34_0_, gisfeature1_.elevation as elevation34_0_, gisfeature1_.gtopo30AverageElevation as gtopo9_34_0_, gisfeature1_.modificationDate as modific10_34_0_, gisfeature1_.name as name34_0_, gisfeature1_.location as location34_0_, gisfeature1_.timeZone as timeZone34_0_, abstractad4_.id as id36_1_, abstractad4_.parentEntity_id as parentEn2_36_1_, abstractad4_.associatedGisFeature_id as associat3_36_1_, abstractad4_1_.iso3166Alpha3Code as iso2_37_1_, abstractad4_1_.fipsCode as fipsCode37_1_, abstractad4_1_.iso3166Alpha2Code as iso4_37_1_, abstractad4_1_.iso3166NumericCode as iso5_37_1_, abstractad4_1_.boundingBoxEast as bounding6_37_1_, abstractad4_1_.boundingBoxNorth as bounding7_37_1_, abstractad4_1_.boundingBoxSouth as bounding8_37_1_, abstractad4_1_.boundingBoxWest as bounding9_37_1_, abstractad4_1_.area as area37_1_, abstractad4_1_.continent_id as continent18_37_1_, abstractad4_1_.population as population37_1_, abstractad4_1_.topLevelDomain as topLeve12_37_1_, abstractad4_1_.phonePrefix as phonePr13_37_1_, abstractad4_1_.postalCodeMask as postalC14_37_1_, abstractad4_1_.equivalentFipsCode as equival15_37_1_, abstractad4_1_.name as name37_1_, abstractad4_1_.currencyCode as currenc17_37_1_, abstractad4_2_.asciiName as asciiName39_1_, abstractad4_2_.name as name39_1_, abstractad4_2_.code as code39_1_, case when abstractad4_1_.id is not null then 1 when abstractad4_2_.id is not null then 2 when abstractad4_.id is not null then 0 end as clazz_1_, abstractad5_.id as id36_2_, abstractad5_.parentEntity_id as parentEn2_36_2_, abstractad5_.associatedGisFeature_id as associat3_36_2_, abstractad5_1_.iso3166Alpha3Code as iso2_37_2_, abstractad5_1_.fipsCode as fipsCode37_2_, abstractad5_1_.iso3166Alpha2Code as iso4_37_2_, abstractad5_1_.iso3166NumericCode as iso5_37_2_, abstractad5_1_.boundingBoxEast as bounding6_37_2_, abstractad5_1_.boundingBoxNorth as bounding7_37_2_, abstractad5_1_.boundingBoxSouth as bounding8_37_2_, abstractad5_1_.boundingBoxWest as bounding9_37_2_, abstractad5_1_.area as area37_2_, abstractad5_1_.continent_id as continent18_37_2_, abstractad5_1_.population as population37_2_, abstractad5_1_.topLevelDomain as topLeve12_37_2_, abstractad5_1_.phonePrefix as phonePr13_37_2_, abstractad5_1_.postalCodeMask as postalC14_37_2_, abstractad5_1_.equivalentFipsCode as equival15_37_2_, abstractad5_1_.name as name37_2_, abstractad5_1_.currencyCode as currenc17_37_2_, abstractad5_2_.asciiName as asciiName39_2_, abstractad5_2_.name as name39_2_, abstractad5_2_.code as code39_2_, case when abstractad5_1_.id is not null then 1 when abstractad5_2_.id is not null then 2 when abstractad5_.id is not null then 0 end as clazz_2_, gisfeature6_.id as id34_3_, gisfeature6_.parentEntity_id as parentE14_34_3_, gisfeature6_.population as population34_3_, gisfeature6_.featureId as featureId34_3_, gisfeature6_.featureSource as featureS4_34_3_, gisfeature6_.featureClass as featureC5_34_3_, gisfeature6_.featureCode as featureC6_34_3_, gisfeature6_.asciiName as asciiName34_3_, gisfeature6_.elevation as elevation34_3_, gisfeature6_.gtopo30AverageElevation as gtopo9_34_3_, gisfeature6_.modificationDate as modific10_34_3_, gisfeature6_.name as name34_3_, gisfeature6_.location as location34_3_, gisfeature6_.timeZone as timeZone34_3_, continent7_.id as id35_4_, continent7_.geonamesCode as geonames2_35_4_, continent7_.geonamesName as geonames3_35_4_ from City this_ inner join GisFeature gisfeature1_ on this_.associatedGisFeature_id=gisfeature1_.id left outer join AbstractAdministrativeEntity abstractad4_ on gisfeature1_.parentEntity_id=abstractad4_.id left outer join Country abstractad4_1_ on abstractad4_.id=abstractad4_1_.id left outer join AdministrativeDivision abstractad4_2_ on abstractad4_.id=abstractad4_2_.id left outer join AbstractAdministrativeEntity abstractad5_ on abstractad4_.parentEntity_id=abstractad5_.id left outer join Country abstractad5_1_ on abstractad5_.id=abstractad5_1_.id left outer join AdministrativeDivision abstractad5_2_ on abstractad5_.id=abstractad5_2_.id left outer join GisFeature gisfeature6_ on abstractad5_.associatedGisFeature_id=gisfeature6_.id left outer join Continent continent7_ on abstractad5_1_.continent_id=continent7_.id where location && setSRID(cast ('BOX3D(-118.75666159581651 33.60255976167443,-117.72889840418348 34.50188023832557)'as box3d), 4326) AND distance_sphere(location, GeomFromText('POINT(-118.24278 34.05222)',4326)) <=  ?