SOCIETE,
DESCRIPTION, 
RES_ID, 
AUTHOR, 
TYPE_ID,
date(CUSTOM_D1) as DATE1, 
date(CUSTOM_D2) as DATE2, 
date(CREATION_DATE) as DATE3, 
STATUS, 
PRIORITY, 
SOCIETE, 
AUTHOR, 
COUNT(notes.ID) AS NBR_NOTE,
COVERAGE, 
DESTINATION