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