SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}Aachen{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}Aachen{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCountry = 'Aachen') AND (prLocation LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}/{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}/{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCountry = '/') AND (prLocation LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}Kornelimünster{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCity = 'Kornelimünster' OR prZip = 'Kornelimünster' OR prStreet LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}Kornelimünster{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCountry = 'Kornelimünster') AND (prLocation LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}Germany{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}Germany{d7fbe3fb5f82d3a9d413e81fa240540050c78e3e23f3e7dac402e58a086887bd}' OR prCountry = 'Germany')