--- dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java	2015/11/17 19:46:10	2774
+++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java	2015/11/19 15:29:36	2775
@@ -140,10 +140,8 @@
 		
 		
 		String sql = "select orgid, a.id as targetid, afstand, LOWER(type) as type from fulddaekning.afstand_anden_rute a " +
-					"join odbc.transporttype t " + 
-					"on t.Art = 'Transpost' " +
-					"and ( (t.Type = 'Cykel' and a.Afstand < 1.001) or (t.Type = 'Scooter' and a.Afstand < 1.201) or (t.Type = 'Bil' and a.Afstand < 2.601) ) " +
-					"and t.Rute = a.Rute " + 
+					"LEFT join odbc.transporttype t " + 
+					"ON (t.Rute = a.Rute) " + 
 					debugFilter1 +
 					
 					"UNION ALL " +