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