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