select concat('http://www.kipeukan.fr/coop?who=',ID,'&xxx=',BGADMDAQ) from PERSONNE where MEL = ''