SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Calvià{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Calvià{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCountry = 'Calvià') AND (prLocation LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}/{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}/{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCountry = '/') AND (prLocation LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Bendinat/Cas{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCity = 'Bendinat/Cas' OR prZip = 'Bendinat/Cas' OR prStreet LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Bendinat/Cas{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCountry = 'Bendinat/Cas') AND (prLocation LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Catala{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCity = 'Catala' OR prZip = 'Catala' OR prStreet LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Catala{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCountry = 'Catala') AND (prLocation LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Spain{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}Spain{644a1837e605410478eee2503302629b1f0746dad0a9ae58d00fe502c28c8c4e}' OR prCountry = 'Spain')