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