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