Error Number: 1054
Unknown column 'u.suku' in 'field list'
SELECT `u`.`suku` AS `nama`, `u`.`suku` AS `id`, COUNT(u.sex) AS jumlah, COUNT(CASE WHEN u.sex = 1 THEN 1 END) AS laki, COUNT(CASE WHEN u.sex = 2 THEN 1 END) AS perempuan FROM `penduduk_hidup` AS `u` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `u`.`id_cluster` = `a`.`id` WHERE `u`.`suku` IS NOT NULL AND `u`.`suku` != "" GROUP BY `u`.`suku`
Filename: models/Laporan_penduduk_model.php
Line Number: 558
Versi OpenSID 22.07. PHP versi 7.4.33.