Kembali Export To Excel

Fatal error: Uncaught CDbException: CDbCommand gagal menjalankan statementSQL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unit.nmunitPembelian' in 'order clause'. The SQL statement executed was: SELECT t.*, count( as JumlahPembelian, if(pembelian.tahun_anggaran is not null,pembelian.tahun_anggaran,'Belum Ada Pembelian') as TahunPembelian, pembelian.status as status_pembelian, departement.nmdept as namadeptPembelian, lokasi.nmlokasi as namalokasiPembelian, kabkota.nmkabkota as namakabkotaPembelian, unit.nmunit as namaunitPembelian FROM `tbl_satker` `t` left outer join tbl_pembelian_langsung pembelian on = pembelian.satker_id and (pembelian.status ='close' or pembelian.status ='sent') left outer join tbl_departement departement on t.kddept = left outer join tbl_kabkota kabkota on t.kdkabkota = kabkota.kdkabkota and t.kdlokasi = kabkota.kdlokasi left outer join tbl_lokasi lokasi on t.kdlokasi = lokasi.kdlokasi left outer join tbl_unit unit on t in /data/www/simpel-deployment/app/lib/vendor/yiisoft/yii/framework/db/CDbCommand.php on line 543