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