Semua program donasi

select SQL_CALC_FOUND_ROWS p.id,p.judul,p.banner,p.ringkasan,p.nominal_terkumpul,p.nominal_target,p.grup_program,m.nama,gp.nominal_target, mb.image from program as p left join grup_kategori as gk on (p.kategori_grup=gk.id) inner join mitra as m on (m.id_mitra=p.id_pengaju) inner join grup_program as gp on (gp.id=p.grup_program) inner join mitra_badge as mb on (mb.id=mitra.badge) where p.status_approve=3 and p.judul!='donasi bebas' order by approve_date DESC LIMIT 0,4