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