--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/10/08 09:16:18 2234 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/11/11 13:45:21 2235 @@ -92,7 +92,8 @@ "AND a.postnr=? " + "AND latitude IS NOT NULL " + "AND longitude IS NOT NULL " + - "AND gadeid IS NOT NULL "; + "AND gadeid IS NOT NULL " + + "AND (a.distributor IS NULL OR a.distributor<>'LUKKET') "; PreparedStatement stmt = conn.prepareStatement(sql); stmt.setInt(1, postnr);