SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}Haan{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}Haan{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}' OR prCountry = 'Haan') AND (prLocation LIKE '{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}Germany{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}Germany{ca2b1da6be68adca1a13ceff9e3dbc992b02613725a227b575a158ff33b00587}' OR prCountry = 'Germany')