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