SELECT *
FROM `tb_sipp_mediasi`
JOIN `pengadilan_negeri` ON `tb_sipp_mediasi`.`satker_id`=`pengadilan_negeri`.`kode`
WHERE `pengadilan_negeri`.`pt_id` = '52'
AND `tb_sipp_mediasi`.`tahun` = 'index.html'
ORDER BY `nama` ASC