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