SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}Venda{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCity = 'Venda' OR prZip = 'Venda' OR prStreet LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}Venda{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCountry = 'Venda') AND (prLocation LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}do{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCity = 'do' OR prZip = 'do' OR prStreet LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}do{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCountry = 'do') AND (prLocation LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}Pinheiro{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCity = 'Pinheiro' OR prZip = 'Pinheiro' OR prStreet LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}Pinheiro{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCountry = 'Pinheiro') AND (prLocation LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}Portugal{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCity = 'Portugal' OR prZip = 'Portugal' OR prStreet LIKE '{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}Portugal{8b031c8aa7033a8d7bf97724feb6263acfeff972064165f94f8daf46509e460f}' OR prCountry = 'Portugal')