104 |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,p.distributor as ho " + |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,p.distributor as ho " + |
105 |
"FROM fulddaekning.adressetabel a " + |
"FROM fulddaekning.adressetabel a " + |
106 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
107 |
"WHERE rute IS NULL " + //Ingen dækning |
"WHERE ruteMa IS NULL " + //Ingen dækning |
108 |
"AND a.postnr BETWEEN ? AND ? " + |
"AND a.postnr BETWEEN ? AND ? " + |
109 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |
110 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
163 |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,p.distributor as ho " + |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,p.distributor as ho " + |
164 |
"FROM fulddaekning.adressetabel a " + |
"FROM fulddaekning.adressetabel a " + |
165 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
166 |
"WHERE rute IS NOT NULL " + |
"WHERE ruteMa IS NOT NULL " + |
167 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |
168 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
169 |
"AND a.distributor = ? "; |
"AND a.distributor = ? "; |