SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Santa{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = 'Santa' OR prZip = 'Santa' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Santa{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = 'Santa') AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Catalina{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = 'Catalina' OR prZip = 'Catalina' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Catalina{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = 'Catalina') AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}/{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}/{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = '/') AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Palma{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = 'Palma' OR prZip = 'Palma' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Palma{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = 'Palma') AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}de{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}de{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = 'de') AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Majorque{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = 'Majorque' OR prZip = 'Majorque' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Majorque{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = 'Majorque') AND (prLocation LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Spain{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}Spain{c0ffec5a6e693dea76f0a107fca0db1bce4e7a96318c67a922ff7587cadce38a}' OR prCountry = 'Spain')