GURU MTs. Muhammadiyah 1 Malang Profil Guru dan Daftar Guru MTs. Muhammadiyah 1 Malang

Maaf, Terdapat Kesalahan 1 SELECT nama,gambar,moto,jalan,alamat_website,facebook,twitter, email,kode_pengajar, GROUP_CONCAT(if(jenis = 'psb', jumlah, NULL)) AS 'jumlah_psb', GROUP_CONCAT(if(jenis = 'blog', jumlah, NULL)) AS 'jumlah_blog' FROM ( SELECT st_master_pengajar.*, count(blog.id) as jumlah, 'blog' as jenis FROM st_master_pengajar,blog WHERE blog.kode_referensi_master_identitas=st_master_pengajar.kode_otomatis GROUP BY st_master_pengajar.kode_otomatis union SELECT st_master_pengajar.*, count(berita.id) as jumlah,'psb' as jenis FROM st_master_pengajar,berita WHERE berita.kode_referensi_pemakai=st_master_pengajar.kode_otomatis GROUP BY st_master_pengajar.kode_otomatis) att GROUP BY nama ORDER BY jumlah_psb DESC,jumlah_blog DESC