SELECT location_address_id, location_code, location_name, route_id FROM Delivery_Route_Locations WHERE "location_address_id" != 13 UNION SELECT location_address_id, location_code, location_name, route_id FROM Delivery_Route_Locations WHERE location_name != "Carter, Pfannerstill and Rutherford" OR "location_address_id" != 4 AND "route_id" = 10 AND location_code = "84 OE Av" <table_name> : Delivery_Route_Locations col : location_code | route_id | location_address_id | location_name row 1 : 27 City Rd | 11 | 5 | Labadie-Crooks row 2 : 30 Sam Rd | 7 | 13 | VonRueden, Schmeler and Fay row 3 : 67 LV Rd | 11 | 6 | Carter, Pfannerstill and Rutherford row 4 : 38 Enisner Av | 10 | 7 | Bradtke-Herman row 5 : 73 Nancy Av | 14 | 10 | Streich Group row 6 : 84 OE Av | 14 | 7 | Hessel and Sons row 7 : 34 Benz St | 2 | 15 | Strosin, Hegmann and Abbott row 8 : 15 Sixth Av | 8 | 6 | Pouros, Brakus and Konopelski row 9 : 04 Elm Rd | 8 | 8 | Hermiston, Hand and Wisoky row 10 : 79 Square St | 15 | 5 | Turner, Dietrich and Smitham row 11 : 84 Temple Rd | 7 | 2 | Leannon, Erdman and Schneider row 12 : 64 Kate Rd | 7 | 12 | Dach Group row 13 : 68 Denny St | 4 | 7 | Ledner-Kozey row 14 : 76 David St | 11 | 3 | Rosenbaum, Kiehn and Kilback row 15 : 58 Roof Av | 13 | 4 | Bartoletti, Keebler and Crona <table_name> : Delivery_Route_Locations col : location_code | route_id | location_address_id | location_name row 1 : 27 City Rd | 11 | 5 | Labadie-Crooks row 2 : 30 Sam Rd | 7 | 13 | VonRueden, Schmeler and Fay row 3 : 67 LV Rd | 11 | 6 | Carter, Pfannerstill and Rutherford row 4 : 38 Enisner Av | 10 | 7 | Bradtke-Herman row 5 : 73 Nancy Av | 14 | 10 | Streich Group row 6 : 84 OE Av | 14 | 7 | Hessel and Sons row 7 : 34 Benz St | 2 | 15 | Strosin, Hegmann and Abbott row 8 : 15 Sixth Av | 8 | 6 | Pouros, Brakus and Konopelski row 9 : 04 Elm Rd | 8 | 8 | Hermiston, Hand and Wisoky row 10 : 79 Square St | 15 | 5 | Turner, Dietrich and Smitham row 11 : 84 Temple Rd | 7 | 2 | Leannon, Erdman and Schneider row 12 : 64 Kate Rd | 7 | 12 | Dach Group row 13 : 68 Denny St | 4 | 7 | Ledner-Kozey row 14 : 76 David St | 11 | 3 | Rosenbaum, Kiehn and Kilback row 15 : 58 Roof Av | 13 | 4 | Bartoletti, Keebler and Crona
col : location_address_id | location_code | location_name | route_id row 1 : 2 | 84 Temple Rd | Leannon, Erdman and Schneider | 7 row 2 : 3 | 76 David St | Rosenbaum, Kiehn and Kilback | 11 row 3 : 4 | 58 Roof Av | Bartoletti, Keebler and Crona | 13 row 4 : 5 | 27 City Rd | Labadie-Crooks | 11 row 5 : 5 | 79 Square St | Turner, Dietrich and Smitham | 15 row 6 : 6 | 15 Sixth Av | Pouros, Brakus and Konopelski | 8 row 7 : 6 | 67 LV Rd | Carter, Pfannerstill and Rutherford | 11 row 8 : 7 | 38 Enisner Av | Bradtke-Herman | 10 row 9 : 7 | 68 Denny St | Ledner-Kozey | 4 row 10 : 7 | 84 OE Av | Hessel and Sons | 14 row 11 : 8 | 04 Elm Rd | Hermiston, Hand and Wisoky | 8 row 12 : 10 | 73 Nancy Av | Streich Group | 14 row 13 : 12 | 64 Kate Rd | Dach Group | 7 row 14 : 13 | 30 Sam Rd | VonRueden, Schmeler and Fay | 7 row 15 : 15 | 34 Benz St | Strosin, Hegmann and Abbott | 2