git diff | grep "var_dump" | wc -l
SELECT
table_date.yar,
table_date.mont,
table_type.type,
COALESCE(table_group.nem, 0) AS nem
FROM
(SELECT DISTINCT yar, mont FROM ...) AS table_date,
(SELECT DISTINCT type FROM ...) AS table_type
LEFT JOIN ( ваш SELECT) AS table_group
ON table_date.yar = table_group.yar
AND table_date.mont = table_group.mont
AND table_type.type = table_group.type