SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}La{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'La' OR prZip = 'La' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}La{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'La') AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Finca{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'Finca' OR prZip = 'Finca' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Finca{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'Finca') AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Golf{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'Golf' OR prZip = 'Golf' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Golf{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'Golf') AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}and{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'and' OR prZip = 'and' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}and{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'and') AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Spa{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'Spa' OR prZip = 'Spa' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Spa{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'Spa') AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Resort{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'Resort' OR prZip = 'Resort' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Resort{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'Resort') AND (prLocation LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Spain{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}Spain{8d2ebe4c7531dceb3b91a5a99286e0d0df0a0d4b42f7879fb0e8c5d17e8b6de6}' OR prCountry = 'Spain')