100 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
101 |
"WHERE rute IS NULL " + //Ingen dækning |
"WHERE rute IS NULL " + //Ingen dækning |
102 |
//"AND a.postnr BETWEEN ? AND ? " + |
//"AND a.postnr BETWEEN ? AND ? " + |
103 |
//"AND a.postnr BETWEEN 8000 and 8600 " + |
"AND a.postnr BETWEEN 8000 and 8600 " + |
104 |
"AND a.postnr BETWEEN 9000 AND 9300 " + |
//"AND a.postnr BETWEEN 9000 AND 9300 " + |
105 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |
106 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
107 |
"AND gadeid IS NOT NULL " + |
"AND gadeid IS NOT NULL " + |