From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 30 Aug 2023 19:52:51 +0000 (+0200)
Subject: remove alias where it does not work with lambdas
X-Git-Tag: v4.3.0~11
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/15e09f2b247d1286a9e43e46d6ab9476eca0bb82?hp=-c

remove alias where it does not work with lambdas

Fixes #3177.
---

15e09f2b247d1286a9e43e46d6ab9476eca0bb82
diff --git a/nominatim/api/search/db_searches.py b/nominatim/api/search/db_searches.py
index 4d893962..e9df3bee 100644
--- a/nominatim/api/search/db_searches.py
+++ b/nominatim/api/search/db_searches.py
@@ -271,7 +271,7 @@ class NearSearch(AbstractSearch):
         """
         table = await conn.get_class_table(*category)
 
-        t = conn.t.placex.alias('p')
+        t = conn.t.placex
         tgeom = conn.t.placex.alias('pgeom')
 
         sql = _select_placex(t).where(tgeom.c.place_id.in_(ids))\