SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Badia{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCity = 'Badia' OR prZip = 'Badia' OR prStreet LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Badia{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCountry = 'Badia') AND (prLocation LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Blava{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCity = 'Blava' OR prZip = 'Blava' OR prStreet LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Blava{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCountry = 'Blava') AND (prLocation LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}/{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}/{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCountry = '/') AND (prLocation LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Badia{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCity = 'Badia' OR prZip = 'Badia' OR prStreet LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Badia{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCountry = 'Badia') AND (prLocation LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Gran{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCity = 'Gran' OR prZip = 'Gran' OR prStreet LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Gran{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCountry = 'Gran') AND (prLocation LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Spain{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}Spain{0fbe1105ff537c73464361d7d00cf8af033c4a41f49e351388c0ce616a1c400c}' OR prCountry = 'Spain')