SELECT publi.id, publi.idparent, publi.publicoll, publi.idconf, conf.titorig as titleconf
         ,COALESCE(collectionlang.collname, collection.collname) as titlecoll, collection.collname, collection.type as colltype, collection.issn
         ,publi.title, publi.title as publititle, publi.titlesub, publi.titlesub as publititlesub, publi.texte, publi.pagerange, publi.note, publi.pagelen 
         ,publi.publidate, publi.publiyear, publi.redacyear, publi.publidated, publi.publidatem, publi.publidatey
         ,publi.recipient, publi.placesent, publi.placedestin, publi.idtarget, publi.idtrad, publi.idorig
         ,publi.publilang, publi.publiplace, publi.edition, publi.isbn
         ,publi.author as publiauthor, publi.editor as publieditor
         ,publi.biblio, publi.footnote, publi.author, publi.editor, publi.translator, publi.contributor
         ,publi.publityp, publi.journal, publi.volume, publi.volume as publivolume, publi.number as publinumber, publi.number, publi.seriesvol, publi.publisher, publi.idmultivol
         ,publi.media, publi.rights, publi.rightsholder, publi.doiname, publi.url, publi.keyword, publi.siteview
         ,IF (rtrim(IFNULL(publi.texte,"")) = "", 0, 1) as textok, publi.publishok, publi.downloadok, publi.nbchildok
         ,parent.id as parentid, parent.journal as parentcollname
         ,parent.title as parentitle, parent.titlesub as parentitlesub, parent.author as parentauthor, parent.editor as parenteditor
         ,parent.publiplace as parentplace, parent.publisher as parentpublisher, parent.publiyear as parentyear
         ,parent.volume as parentvolume, parent.number as parentnumber
         ,target.title as targettitle, target.author as targetauthor, target.editor as targeteditor      
        FROM publi publi
         LEFT OUTER JOIN publi parent ON publi.idparent = parent.id
         LEFT OUTER JOIN publi target ON publi.idtarget = target.id
         LEFT OUTER JOIN collection on (publi.publicoll = collection.code)
         LEFT OUTER JOIN collectionlang on collection.code = collectionlang.code and collectionlang.lang = "en"
         LEFT OUTER JOIN  conf on conf.id = publi.idconf
        WHERE publi.id = 106657