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