introduce Result class in Geocode and SearchDescription

[nominatim.git] / website / deletable.php

diff --git a/website/deletable.php b/website/deletable.php
index d99eb5d144e0e6e785d13da4cb1ff3523c6f7cd8..95000032f390aa841aab19b33cab6fbaf3751f7c 100755 (executable)
--- a/website/deletable.php
+++ b/website/deletable.php
@@ -10,7 +10,10 @@ $sOutputFormat = 'html';
 
 $oDB =& getDB();
 
 
 $oDB =& getDB();
 

-$sSQL = "select placex.place_id, calculated_country_code as country_code, name->'name' as name, i.* from placex, import_polygon_delete i where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type and placex.class = i.class and placex.type = i.type";
+$sSQL = "select placex.place_id, country_code,";
+$sSQL .= " name->'name' as name, i.* from placex, import_polygon_delete i";
+$sSQL .= " where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type";
+$sSQL .= " and placex.class = i.class and placex.type = i.type";

 $aPolygons = chksql($oDB->getAll($sSQL), "Could not get list of deleted OSM elements.");
 
 if (CONST_Debug) {
 $aPolygons = chksql($oDB->getAll($sSQL), "Could not get list of deleted OSM elements.");
 
 if (CONST_Debug) {