| 0.0282 |
SELECT bahasa.nama as bahasa_nama, u.sex as id_sex, u.*, a.dusun, a.rw, a.rt, t.id AS id_status, t.nama AS status, o.nama AS pendidikan_sedang, m.nama as golongan_darah, h.nama as hubungan, b.nama AS pendidikan_kk, d.no_kk AS no_kk, d.alamat, u.id_cluster as id_cluster, ux.nama as nama_pengubah, ucreate.nama as nama_pendaftar, polis.nama AS asuransi, (CASE when u.status_kawin IS NULL then '' when u.status_kawin <> 2 then k.nama else case when u.akta_perkawinan = '' then 'KAWIN BELUM TERCATAT' else 'KAWIN TERCATAT' end end) as kawin, (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(`tanggallahir`)), '%Y')+0 FROM tweb_penduduk WHERE id = u.id) AS umur, x.nama AS sex, w.nama AS warganegara, p.nama AS pekerjaan, g.nama AS agama, c.nama as cacat, kb.nama as cara_kb, sm.nama as sakit_menahun, sd.nama as status_dasar, u.status_dasar as status_dasar_id, (select tweb_penduduk.nama AS nama from tweb_penduduk where (tweb_penduduk.id = d.nik_kepala)) AS kepala_kk, log.no_kk as log_no_kk, log.tgl_lapor as tgl_lapor, log.tgl_peristiwa as tgl_peristiwa FROM tweb_penduduk u LEFT JOIN tweb_keluarga d ON u.id_kk = d.id LEFT JOIN tweb_wil_clusterdesa a ON u.id_cluster = a.id LEFT JOIN tweb_penduduk_pendidikan o ON u.pendidikan_sedang_id = o.id LEFT JOIN tweb_penduduk_pendidikan_kk b ON u.pendidikan_kk_id = b.id LEFT JOIN tweb_penduduk_warganegara w ON u.warganegara_id = w.id LEFT JOIN tweb_penduduk_status t ON u.status = t.id LEFT JOIN tweb_penduduk_pekerjaan p ON u.pekerjaan_id = p.id LEFT JOIN tweb_penduduk_kawin k ON u.status_kawin = k.id LEFT JOIN tweb_penduduk_sex x ON u.sex = x.id LEFT JOIN tweb_penduduk_agama g ON u.agama_id = g.id LEFT JOIN tweb_golongan_darah m ON u.golongan_darah_id = m.id LEFT JOIN tweb_penduduk_hubungan h on u.kk_level = h.id LEFT JOIN tweb_cacat c ON u.cacat_id = c.id LEFT JOIN tweb_sakit_menahun sm ON u.sakit_menahun_id = sm.id LEFT JOIN tweb_cara_kb kb ON u.cara_kb_id = kb.id LEFT JOIN tweb_status_dasar sd ON u.status_dasar = sd.id LEFT JOIN log_penduduk log ON u.id = log.id_pend LEFT JOIN user ux ON u.updated_by = ux.id LEFT JOIN user ucreate ON u.created_by = ucreate.id LEFT JOIN tweb_penduduk_asuransi polis ON polis.id = u.id_asuransi LEFT JOIN ref_penduduk_bahasa bahasa ON bahasa.id = u.bahasa_id WHERE u.id='100'
|