X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/e1be3d9f48b51a927c26d1ac0035b50b82423916..924d3a8d6e9d5557f5d0d7b0f22f49a0d524a768:/website/deletable.php diff --git a/website/deletable.php b/website/deletable.php index 90eb40c8..531bdadb 100755 --- a/website/deletable.php +++ b/website/deletable.php @@ -10,10 +10,13 @@ $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"; +$sSQL = "select placex.place_id, calculated_country_code as 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) { +if (CONST_Debug) { var_dump($aPolygons); exit; }