~~NOCACHE~~
====== AG - Feuille d'émargement ======

===== Assemblée Générale du 14/03/2019 =====

<sql>
SELECT 
CONCAT("<b><a href='https://gestioncafe.reseauanais.fr/adherents/card.php?rowid=",adherent.rowid,"' target='_tab' >",adherent.rowid,"</a></b>") as 'Id',
CONCAT("<h1>",`firstname`,' ',`lastname`,"</h1>") as '<h1>Nom</h1>',
"<br/><br/>____________________________________________<br/><br/></h1>" as '<h1> Signature </h1>' 

FROM `llx89_adherent` as adherent

WHERE 
 statut=1 and date_format(datefin,'%Y') > '2018'
GROUP BY 
`firstname`,
`lastname`
</sql>



[[.:|Retour à la gouvernance]]