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