SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}Calonge{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}' OR prCity = 'Calonge' OR prZip = 'Calonge' OR prStreet LIKE '{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}Calonge{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}' OR prCountry = 'Calonge') AND (prLocation LIKE '{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}Spain{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}Spain{47167209e2944a5a946fe2af2a6e5187b558b7c0a4146e2a779cd8e20d7edaaa}' OR prCountry = 'Spain')