SELECT
    mr.NAME_REGIONAL,
    ma.NAME_AREA,
    temp.YEAR,
    temp.MONTH,
    temp.TransactionCount
FROM
    `md_regional` mr
JOIN
    `md_area` ma ON ma.ID_REGIONAL = mr.ID_REGIONAL
LEFT JOIN
    (
        SELECT
        	t.AREA_TRANS,
            YEAR(t.DATE_TRANS) AS Year,
            MONTH(t.DATE_TRANS) AS Month,
            SUM(td.QTY_TD) AS TransactionCount
        FROM
            `transaction` t
        JOIN `transaction_detail` td ON td.ID_TRANS = t.ID_TRANS
        JOIN `md_product` mp ON mp.ID_PRODUCT = td.ID_PRODUCT
        JOIN `md_product_category` mpc ON mpc.ID_PC = mp.ID_PC
        WHERE
            YEAR(t.DATE_TRANS) = :selectedYear
            AND mpc.ID_PC = :selectedCat
        GROUP BY
            YEAR(t.DATE_TRANS),
            MONTH(t.DATE_TRANS)
        ORDER BY
            YEAR(t.DATE_TRANS),
            MONTH(t.DATE_TRANS)
    ) temp ON
    temp.AREA_TRANS = ma.NAME_AREA
GROUP BY
    mr.NAME_REGIONAL,
    ma.NAME_AREA
ORDER BY
    mr.NAME_REGIONAL,
    ma.NAME_AREA ASC