SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}Haren{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}' OR prCity = 'Haren' OR prZip = 'Haren' OR prStreet LIKE '{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}Haren{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}' OR prCountry = 'Haren') AND (prLocation LIKE '{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}(Ems){67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}' OR prCity = '(Ems)' OR prZip = '(Ems)' OR prStreet LIKE '{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}(Ems){67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}' OR prCountry = '(Ems)') AND (prLocation LIKE '{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}Germany{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}Germany{67a854c2893499a37848144c4019c671af1c939e9f6b0c0818f7b8a88abfcbba}' OR prCountry = 'Germany')