SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}Calvià{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}Calvià{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCountry = 'Calvià') AND (prLocation LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}/{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}/{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCountry = '/') AND (prLocation LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}Peguera{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCity = 'Peguera' OR prZip = 'Peguera' OR prStreet LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}Peguera{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCountry = 'Peguera') AND (prLocation LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}Spain{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}Spain{941ee8027aba54d9ae89d31d1b258b33bee600b73c9f174783442e550cd264b1}' OR prCountry = 'Spain')
