102 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
103 |
"WHERE rute IS NULL " + //Ingen dækning |
"WHERE rute IS NULL " + //Ingen dækning |
104 |
"AND a.postnr BETWEEN ? AND ? " + |
"AND a.postnr BETWEEN ? AND ? " + |
105 |
|
"AND a.postnr NOT BETWEEN 3900 and 3999 " + //Skip greenland |
106 |
|
"AND a.postnr NOT BETWEEN 9000 AND 9499 " + // Skip nordjylland (DAO) |
107 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |
108 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
109 |
"AND gadeid IS NOT NULL " + |
"AND gadeid IS NOT NULL " + |