Ver originalSELECT p.user, COUNT( p.id ) TotalEventosFROM participantes pGROUP BY p.userORDER BY p.user ASC
Ver originalSELECT e.id, IFNULL(COUNT(p.user),0) TotalParticipantesFROM events e LEFT JOIN participantes p ON e.id= p.id GROUP BY e.idORDER BY e.event_start DESC , e.id ASC