Nagari Sungai Kamuyang

SHOW TABLES FROM `c1_db_sngikamuyng` 0.0015 sec

SELECT * FROM `setting_aplikasi` ORDER BY `key` 0.0002 sec

SHOW DATABASES 0.0009 sec

SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'c1_db_sngikamuyng' AND table_name = 'user' 0.0006 sec

SELECT * FROM `migrasi` WHERE `versi_database` = '2021120101' 0.0001 sec

SELECT (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1) AS pend, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =1 AND warganegara_id <> 2) AS wni_lk, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =2 AND warganegara_id <> 2) AS wni_pr, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =1 AND warganegara_id = 2) AS wna_lk, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =2 AND warganegara_id = 2) AS wna_pr, (SELECT COUNT(p.id) FROM tweb_keluarga k LEFT JOIN tweb_penduduk p ON k.nik_kepala = p.id WHERE p.status_dasar = 1 AND k.nik_kepala IS NOT NULL AND k.nik_kepala <> 0) AS kk, (SELECT COUNT(k.id) FROM tweb_keluarga k LEFT JOIN tweb_penduduk p ON k.nik_kepala = p.id WHERE p.sex = 1 AND p.status_dasar = 1) AS kk_lk, (SELECT COUNT(k.id) FROM tweb_keluarga k LEFT JOIN tweb_penduduk p ON k.nik_kepala = p.id WHERE p.sex = 2 AND p.status_dasar = 1) AS kk_pr 0.0001 sec

SELECT * FROM log_bulanan WHERE month(tgl) = 05 AND year(tgl) = 2025 0.0001 sec

UPDATE `log_bulanan` SET `pend` = '355', `wni_lk` = '166', `wni_pr` = '188', `wna_lk` = '0', `wna_pr` = '1', `kk` = '111', `kk_lk` = '83', `kk_pr` = '28' WHERE month(tgl) = 05 AND year(tgl) = 2025 0.0021 sec

SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa FROM `config` `c` LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id` LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id` 0.0001 sec