X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/248fca51627a8989603344e813bf78e3131de4a8..203b5f7de12ca09d275103eb2eb70fe5a4c20466:/website/deletable.php diff --git a/website/deletable.php b/website/deletable.php index d99eb5d1..6e9178e0 100755 --- a/website/deletable.php +++ b/website/deletable.php @@ -10,8 +10,11 @@ $sOutputFormat = 'html'; $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"; -$aPolygons = chksql($oDB->getAll($sSQL), "Could not get list of deleted OSM elements."); +$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) { var_dump($aPolygons); @@ -70,14 +73,14 @@ table td { "; +echo '