SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}Lloret{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCity = 'Lloret' OR prZip = 'Lloret' OR prStreet LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}Lloret{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCountry = 'Lloret') AND (prLocation LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}de{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}de{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCountry = 'de') AND (prLocation LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}Mar{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCity = 'Mar' OR prZip = 'Mar' OR prStreet LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}Mar{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCountry = 'Mar') AND (prLocation LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}Spain{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}Spain{cf9d95973e56ffd1850aa9bbcfdfdf08778b171a6bca882601b63375e1d496bb}' OR prCountry = 'Spain')