Join con tabella a record vuoti

[Magicale]

SELECT series.*, COUNT(DISTINCT programs.series_season) as seasons, 
COUNT(programs.id) AS episodes FROM series 
LEFT JOIN programs ON series.id = programs.series_id
GROUP BY series.id