lpad(MONTH(a.payment_date), 2, '0') AS MONTH<br/>lpad(MONTH(a.payment_date), 2, '0') AS MONTH<br/>count(a.id) AS count<br/>count(a.id) AS count<br/>( 
SELECT COALESCE( count(b.id), 0 )
FROM #__cbsubs_donations AS b 
WHERE
b.plan_id = 1 and 
b.payment_date BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' 
AND b.status = 'A'  AND MONTH(b.payment_date) = MONTH(a.payment_date)
AND b.user_id not in (375)
GROUP BY MONTH(b.payment_date)
) AS count_24<br/>( 
SELECT COALESCE( count(b.id), 0 )
FROM #__cbsubs_donations AS b 
WHERE
b.plan_id = 1 and 
b.payment_date BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' 
AND b.status = 'A'  AND MONTH(b.payment_date) = MONTH(a.payment_date)
AND b.user_id not in (375)
GROUP BY MONTH(b.payment_date)
) AS count_24<br/>(

COALESCE( (SELECT count(c.id)
FROM #__cbsubs_donations AS c 
WHERE
c.plan_id = 1 and 
c.payment_date BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' 
AND c.status = 'A'  AND MONTH(c.payment_date) = MONTH(a.payment_date)
AND c.user_id not in (375)
GROUP BY MONTH(c.payment_date) ), 'null' )
) AS count_25<br/>(

COALESCE( (SELECT count(c.id)
FROM #__cbsubs_donations AS c 
WHERE
c.plan_id = 1 and 
c.payment_date BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' 
AND c.status = 'A'  AND MONTH(c.payment_date) = MONTH(a.payment_date)
AND c.user_id not in (375)
GROUP BY MONTH(c.payment_date) ), 'null' )
) AS count_25<br/>(

COALESCE( (SELECT count(c.id)
FROM #__cbsubs_donations AS c 
WHERE
c.plan_id = 1 and 
c.payment_date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' 
AND c.status = 'A'  AND MONTH(c.payment_date) = MONTH(a.payment_date)
AND c.user_id not in (375)
GROUP BY MONTH(c.payment_date) ), 
CASE 
    WHEN MONTH(a.payment_date) = MONTH(CURDATE())  THEN 0
    ELSE 'null'
END)
) AS count_26<br/>(

COALESCE( (SELECT count(c.id)
FROM #__cbsubs_donations AS c 
WHERE
c.plan_id = 1 and 
c.payment_date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' 
AND c.status = 'A'  AND MONTH(c.payment_date) = MONTH(a.payment_date)
AND c.user_id not in (375)
GROUP BY MONTH(c.payment_date) ), 
CASE 
    WHEN MONTH(a.payment_date) = MONTH(CURDATE())  THEN 0
    ELSE 'null'
END)
) AS count_26<br/>