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