SELECT `inscription_id`, 
`membre_id`, 
`numordre`, 
`inscriptions`.`session_id`, 
`civilite`,
CONCAT (`nom`,' ', `postnom`,' ', `prenom`) AS `participant`,
`inscriptions`.`email`, 
`inscriptions`.`numtel`, 
`inscriptions`.`datecre`, 
`preuvepaie`,
`numtransac`,
`attestation`,
IF (`statut`=1, "enregistrée",IF (`statut`=2, "validée", "suivie")) AS statut,
IF (`numordre`='',"non","oui") AS siec,

IF (`statut`=1 OR `statut`=2, CONCAT("<a title='modifier' href='maj-inscription-forco?id=",inscription_id,"'><i class='line-icon icon-pencil'></i></a>"),IF (`statut`=3, CONCAT("<a title='attestation' target=_blank href='",attestation,"'><i class='line-icon icon-trophy'></i></a>"),"") 
) AS A,

IF (`statut`='1', CONCAT("<a class='suppr' title='supprimer' href='inscriptions-session-forco?op=suppr&id=",inscription_id,"'><i id='",inscription_id,"' class='line-icon icon-trash'></i></a>"),
        CONCAT("<a>&lt;input class='choix' type='checkbox' id='",inscription_id,"'&gt;</a>")) AS B

FROM `inscriptions` 
LEFT JOIN `sessions` ON `sessions`.`session_id` = `inscriptions`.`session_id` 
WHERE `sessions`.`session_id`=%VAR1%