SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Calvià{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Calvià{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCountry = 'Calvià') AND (prLocation LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}/{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}/{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCountry = '/') AND (prLocation LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Costa{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCity = 'Costa' OR prZip = 'Costa' OR prStreet LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Costa{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCountry = 'Costa') AND (prLocation LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}d\\\\\'en{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCity = 'd\\\\\'en' OR prZip = 'd\\\\\'en' OR prStreet LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}d\\\\\'en{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCountry = 'd\\\\\'en') AND (prLocation LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Blanes{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCity = 'Blanes' OR prZip = 'Blanes' OR prStreet LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Blanes{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCountry = 'Blanes') AND (prLocation LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Spain{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}Spain{e636a90d2a72cb20174caba2aaa236d96045cafa99605e1281a141f3212d4a37}' OR prCountry = 'Spain')