SELECT
                a.payment_id,
                d.project_id,d.name as project,
                e.pt_id,e.name as pt,
                a.reference_no,
                a.payment_no,
				a.note,
                b.unit_number,
                c.code as cluster_code,
                c.cluster,
                a.payment_date,
				f.paymentmethod,
                a.total_payment,
                CONVERT(varchar(15), payment_date, 121) AS transdate
            FROM th_payment a with (nolock)
            LEFT JOIN m_unit b ON b.unit_id = a.unit_id
            LEFT JOIN mh_cluster c ON c.cluster_id = b.cluster_id
            LEFT JOIN dbmaster.dbo.m_project d ON d.project_id = b.project_id
            LEFT JOIN dbmaster.dbo.m_pt e ON e.pt_id = b.pt_id
            LEFT JOIN m_paymentmethod f ON f.paymentmethod_id = a.paymentmethod_id
            WHERE            
                a.Deleted = 0
                AND a.is_cancel = 0
                AND b.project_id =2075
                AND b.pt_id =2097
                AND (convert(date,a.Addon) BETWEEN '2026-08-07' AND '2026-10-06'  OR convert(date,a.Modion) BETWEEN '2026-08-07' AND '2026-10-06')