SELECT nomor_perkara_pn,permohonan_banding,pengiriman_berkas_banding,nomor_perkara_banding,putusan_banding
FROM pastb.perkara_banding
where status_banding_text='Permohonan Banding' AND DATEDIFF(NOW(),permohonan_banding) > 30
and YEAR(permohonan_banding)=YEAR(NOW())
Dashboard SIPP PTA