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