select *,InscriptionCount+ConfirmationCount as TotalFROM (SELECT s1.user, s1.date_inscription, ( SELECT COUNT( * ) FROM jos_chronoforms_si s2 WHERE s2.date_inscription = s1.date_inscription AND s2.user = s1.user AND s2.action = "Inscription" ) as InscriptionCount, ( SELECT COUNT( * ) FROM jos_chronoforms_si s2 WHERE s2.date_inscription = s1.date_inscription AND s2.user = s1.user AND s2.action = "Confirmation" ) as ConfirmationCountFROM jos_chronoforms_si s1GROUP BY s1.user, s1.date_inscription) as x