SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}Cala{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}Cala{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}' OR prCountry = 'Cala') AND (prLocation LIKE '{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}Major{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}Major{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}' OR prCountry = 'Major') AND (prLocation LIKE '{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}Spain{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}Spain{07110037c53346aba0f9ed7c68e27527781884f49a1adf30417b6deaf1b51dae}' OR prCountry = 'Spain')