SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}Cannes{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}' OR prCity = 'Cannes' OR prZip = 'Cannes' OR prStreet LIKE '{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}Cannes{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}' OR prCountry = 'Cannes') AND (prLocation LIKE '{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}France{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}' OR prCity = 'France' OR prZip = 'France' OR prStreet LIKE '{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}France{4bce1c84e1b5a8f44ad322a14338bde7a57527733ea2a12267b38263e3ee1162}' OR prCountry = 'France')