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