1 | SHOW FULL COLUMNS FROM `data_asatu_pelapor` | | 65 | 65 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 |
3 | SHOW FULL COLUMNS FROM `provinces` | | 19 | 19 | 1 |
4 | SHOW FULL COLUMNS FROM `users` | | 16 | 16 | 1 |
5 | SHOW FULL COLUMNS FROM `user_levels` | | 5 | 5 | 0 |
6 | SHOW FULL COLUMNS FROM `kabupaten` | | 7 | 7 | 0 |
7 | SHOW FULL COLUMNS FROM `panwaslu` | | 4 | 4 | 0 |
8 | SHOW FULL COLUMNS FROM `tipe_pilkada` | | 3 | 3 | 0 |
9 | SHOW FULL COLUMNS FROM `kota` | | 4 | 4 | 0 |
10 | SHOW FULL COLUMNS FROM `jenis_pelanggaran` | | 5 | 5 | 1 |
11 | SHOW FULL COLUMNS FROM `pekerjaan` | | 5 | 5 | 0 |
12 | SHOW FULL COLUMNS FROM `jabatan_terlapor` | | 5 | 5 | 1 |
13 | SHOW FULL COLUMNS FROM `tahapan` | | 5 | 5 | 0 |
14 | SHOW FULL COLUMNS FROM `sub_tahapan` | | 6 | 6 | 0 |
15 | SHOW FULL COLUMNS FROM `trend_administrasi` | | 7 | 7 | 0 |
16 | SHOW FULL COLUMNS FROM `tindak_lanjut` | | 5 | 5 | 1 |
17 | SHOW FULL COLUMNS FROM `trend_hukum_lain` | | 5 | 5 | 0 |
18 | SHOW FULL COLUMNS FROM `trend_kode_etik` | | 5 | 5 | 0 |
19 | SHOW FULL COLUMNS FROM `registrasi` | | 5 | 5 | 0 |
20 | SHOW FULL COLUMNS FROM `putusan` | | 5 | 5 | 0 |
21 | SHOW FULL COLUMNS FROM `menus` | | 13 | 13 | 0 |
22 | SHOW FULL COLUMNS FROM `menu_types` | | 3 | 3 | 0 |
23 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`menu_type_id`, `Menu`.`slug`, `Menu`.`link`, `Menu`.`content`, `Menu`.`order`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `MenuType`.`id`, `MenuType`.`name`, `MenuType`.`is_active` FROM `menus` AS `Menu` LEFT JOIN `menu_types` AS `MenuType` ON (`Menu`.`menu_type_id` = `MenuType`.`id`) WHERE `Menu`.`parent_id` IS NULL AND `Menu`.`is_active` = 1 ORDER BY `Menu`.`order` ASC | | 7 | 7 | 1 |
24 | SHOW FULL COLUMNS FROM `messages` | | 8 | 8 | 0 |
25 | SELECT `Message`.`id`, `Message`.`province_id`, `Message`.`sender_user_id`, `Message`.`receiver_user_id`, `Message`.`pesan`, `Message`.`is_view`, `Message`.`created`, `Message`.`modified`, `Sender`.`id`, `Sender`.`username`, `Sender`.`password`, `Sender`.`type`, `Sender`.`name`, `Sender`.`province_id`, `Sender`.`kabupaten_id`, `Sender`.`panwaslu_id`, `Sender`.`user_level_id`, `Sender`.`activity_id`, `Sender`.`email`, `Sender`.`is_access`, `Sender`.`last_login`, `Sender`.`is_active`, `Sender`.`created`, `Sender`.`modified`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`password`, `Receiver`.`type`, `Receiver`.`name`, `Receiver`.`province_id`, `Receiver`.`kabupaten_id`, `Receiver`.`panwaslu_id`, `Receiver`.`user_level_id`, `Receiver`.`activity_id`, `Receiver`.`email`, `Receiver`.`is_access`, `Receiver`.`last_login`, `Receiver`.`is_active`, `Receiver`.`created`, `Receiver`.`modified`, `Province`.`id`, `Province`.`nama`, `Province`.`koordinat_x`, `Province`.`koordinat_y`, `Province`.`map`, `Province`.`map_width`, `Province`.`map_height`, `Province`.`profile`, `Province`.`logo`, `Province`.`daerah`, `Province`.`latitude`, `Province`.`longtitude`, `Province`.`is_active`, `Province`.`urut`, `Province`.`corxy`, `Province`.`struktur_bawaslu`, `Province`.`email`, `Province`.`created`, `Province`.`modified` FROM `messages` AS `Message` LEFT JOIN `users` AS `Sender` ON (`Message`.`sender_user_id` = `Sender`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Message`.`receiver_user_id` = `Receiver`.`id`) LEFT JOIN `provinces` AS `Province` ON (`Message`.`province_id` = `Province`.`id`) WHERE ((`Message`.`province_id` IS NULL) OR (`Message`.`sender_user_id` IS NULL)) AND `Message`.`is_view` = 0 | | 0 | 0 | 0 |