SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Manacor{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCity = 'Manacor' OR prZip = 'Manacor' OR prStreet LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Manacor{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCountry = 'Manacor') AND (prLocation LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}/{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}/{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCountry = '/') AND (prLocation LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Cala{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Cala{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCountry = 'Cala') AND (prLocation LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Murada{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCity = 'Murada' OR prZip = 'Murada' OR prStreet LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Murada{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCountry = 'Murada') AND (prLocation LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Spain{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}Spain{1adcdc5fd1ec38569db33eb771f179801a391c6f34bbc121229295035ac1d000}' OR prCountry = 'Spain')