report query

SELECT DISTINCT
    l.*
FROM
    goal AS g
        LEFT JOIN
    hamiddomain.user_lead AS ul ON g.fk_id_user = ul.fk_id_user
        LEFT JOIN
    hamiddomain.lead AS l ON l.id_lead = ul.fk_id_lead
WHERE
    g.fk_id_user = 5 AND g.data_status = 1
        AND g.is_deleted = 0 AND g.time_period_type = 0 AND YEAR(now())=YEAR(l.created_at)
UNION
SELECT DISTINCT
    l.*
FROM
    goal AS g
        LEFT JOIN
    hamiddomain.user_lead AS ul ON g.fk_id_user = ul.fk_id_user
        LEFT JOIN
    hamiddomain.lead AS l ON l.id_lead = ul.fk_id_lead
WHERE
    g.fk_id_user = 5 AND g.data_status = 1
        AND g.is_deleted = 0 AND g.time_period_type = 1 AND QUARTER(now())=QUARTER(l.created_at)
UNION
SELECT DISTINCT
    l.*
FROM
    goal AS g
        LEFT JOIN
    hamiddomain.user_lead AS ul ON g.fk_id_user = ul.fk_id_user
        LEFT JOIN
    hamiddomain.lead AS l ON l.id_lead = ul.fk_id_lead
WHERE
    g.fk_id_user = 5 AND g.data_status = 1
        AND g.is_deleted = 0 AND g.time_period_type = 2 AND MONTH(now())=MONTH(l.created_at)
UNION
SELECT DISTINCT
    l.*
FROM
    goal AS g
        LEFT JOIN
    hamiddomain.user_lead AS ul ON g.fk_id_user = ul.fk_id_user
        LEFT JOIN
    hamiddomain.lead AS l ON l.id_lead = ul.fk_id_lead
WHERE
    g.fk_id_user = 5 AND g.data_status = 1
        AND g.is_deleted = 0 AND g.time_period_type = 3 AND WEEK(now())=WEEK(l.created_at)
UNION
SELECT DISTINCT
    l.*
FROM
    goal AS g
        LEFT JOIN
    hamiddomain.user_lead AS ul ON g.fk_id_user = ul.fk_id_user
        LEFT JOIN
    hamiddomain.lead AS l ON l.id_lead = ul.fk_id_lead
WHERE
    g.fk_id_user = 5 AND g.data_status = 1
        AND g.is_deleted = 0 AND g.time_period_type = 4 AND DAY(now())=DAY(l.created_at);