SHOW TABLES FROM `ds_sesepandb`
0.0012 sec
SHOW DATABASES
0.0003 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'ds_sesepandb' AND table_name = 'user'
0.0002 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '192.168.123.97'
OR `id_pengunjung` IS NULL
)
AND `status` = 1
ORDER BY `tipe` ASC
0.0002 sec
SELECT `status_rekam`, LOWER(nama) as nama
FROM `tweb_status_ktp`
0.0002 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama`
FROM `analisis_master` `u`
LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id`
WHERE `u`.`id` IS NULL
0.0002 sec
SELECT *
FROM `analisis_periode`
WHERE `aktif` = 1
AND `id_master` IS NULL
0.0001 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama`
FROM `analisis_master` `u`
LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id`
WHERE `u`.`id` IS NULL
0.0002 sec
SELECT `id`
FROM `artikel`
WHERE `slug` = 'apbdes-2022'
OR `id` = 'apbdes-2022'
0.0002 sec
UPDATE `artikel` SET hit = hit + 1
WHERE `id` = '2'
0.0010 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2024-04-28 00:53:32'
AND YEAR(a.tgl_upload) = '2023'
AND MONTH(a.tgl_upload) = '11'
AND DAY(a.tgl_upload) = '9'
AND `a`.`slug` = 'apbdes-2022'
0.0005 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` = '4.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT `Kelompok`, `Nama_Kelompok`
FROM `keuangan_manual_ref_rek2`
WHERE `Akun` = '4.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '4.1.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.1.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '4.2.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.2.5.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '4.3.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.5.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.6.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.6.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.9.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.3.9.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` = '5.'
0.0001 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT `Kelompok`, `Nama_Kelompok`
FROM `keuangan_manual_ref_rek2`
WHERE `Akun` = '5.'
0.0001 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '5.1.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.1.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '5.2.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.5.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.6.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.6.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.7.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.2.7.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '5.3.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.5.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.6.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.6.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.7.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.7.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.8.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.8.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.9.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.3.9.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.4.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '5.4.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.4.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.4.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_manual_ref_bidang`
0.0001 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.01%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.01%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.02%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.02%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.03%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.03%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.04%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.04%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.05%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE LEFT(Kd_Keg, 10) LIKE '00.0000.05%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` = '6.'
0.0001 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT `Kelompok`, `Nama_Kelompok`
FROM `keuangan_manual_ref_rek2`
WHERE `Akun` = '6.'
AND `Kelompok` = '6.1.'
0.0001 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '6.1.'
AND `Kelompok` = '6.1.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.3.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.3.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.9.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.1.9.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` = '6.'
0.0001 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS Akun, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Akun`
0.0002 sec
SELECT `Kelompok`, `Nama_Kelompok`
FROM `keuangan_manual_ref_rek2`
WHERE `Akun` = '6.'
AND `Kelompok` = '6.2.'
0.0001 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT LEFT(Kd_Rincian, 4) AS Kelompok, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Kelompok`
0.0002 sec
SELECT `Kelompok`, `Jenis`, `Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `Kelompok` = '6.2.'
AND `Kelompok` = '6.2.'
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.1.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.1.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.2.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.2.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.9.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS Jenis, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '6.2.9.%' ESCAPE '!'
AND `keuangan_manual_rinci`.`Tahun` = '2022'
GROUP BY `Jenis`
0.0002 sec
SELECT *
FROM `agenda`
WHERE `id_artikel` = '2'
0.0002 sec
SELECT *
FROM `komentar`
WHERE `id_artikel` = '2'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0002 sec
SELECT *
FROM `widget`
WHERE `jenis_widget` <> 3
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2024-04-28'
0.0002 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"192.168.123.97\",\"192.168.123.97\"]}', `Jumlah` = 2
WHERE `Tanggal` = '2024-04-28'
0.0008 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2024-04-28'
0.0002 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2024-04-27'
0.0002 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE (
`id` = 'berita-desa'
OR `slug` = 'berita-desa'
)
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '1'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '2'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel`
WHERE `id` = '3'
0.0002 sec
SELECT *
FROM `kategori`
WHERE (
`id` = 'berita-lainnya'
OR `slug` = 'berita-lainnya'
)
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '13'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '3'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '4'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel`
WHERE `id` = '2'
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '5'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '6'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '7'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '1'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '4'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '5'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '6'
ORDER BY `urut`
0.0001 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '9'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0006 sec
SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload`
FROM `teks_berjalan` `t`
LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id`
WHERE `tipe` = 1
AND `status` = 1
ORDER BY `urut`
0.0002 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar` != ''
AND `tgl_upload` < '2024-04-28 00:53:32'
UNION
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar1` != ''
AND `tgl_upload` < '2024-04-28 00:53:32'
UNION
(SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar2` != ''
AND `tgl_upload` < '2024-04-28 00:53:32')
UNION
(SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar3` != ''
AND `tgl_upload` < '2024-04-28 00:53:32')ORDER BY RAND() LIMIT 10
0.0004 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar` != ''
AND `tgl_upload` < '2024-04-28 00:53:32'ORDER BY tgl_upload DESC LIMIT 10
0.0002 sec
SELECT *
FROM `widget`
WHERE `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4
0.0002 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `agenda` `g`
LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
AND DATE(g.tgl_agenda) = CURDATE()
0.0003 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `agenda` `g`
LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
AND DATE(g.tgl_agenda) > CURDATE()
ORDER BY `g`.`tgl_agenda`
0.0002 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `agenda` `g`
LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
AND DATE(g.tgl_agenda) < CURDATE()
0.0003 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.*
FROM `komentar` `k`
JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id`
WHERE `k`.`status` = 1
AND `k`.`id_artikel` <> 775
ORDER BY `k`.`tgl_upload` DESC
LIMIT 10
0.0002 sec
SELECT *
FROM `media_sosial`
WHERE `enabled` = 1
0.0002 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2024-04-28 00:53:32'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0003 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2024-04-28 00:53:32'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0003 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2024-04-28 00:53:32'
ORDER BY rand()
LIMIT 7
0.0008 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama
FROM `tweb_desa_pamong` `dp`
LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend`
LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id`
WHERE `dp`.`pamong_status` = '1'
ORDER BY `dp`.`urut`
0.0003 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan
FROM `tweb_penduduk_sex` `u`
LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.0007 sec
SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan
FROM `penduduk_hidup` `b`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id`
0.0004 sec
SELECT `setting`
FROM `widget`
WHERE `isi` = 'sinergi_program.php'
0.0002 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
ORDER BY `tahun_anggaran` DESC
0.0001 sec
SELECT `Tahun`
FROM `keuangan_manual_rinci`
GROUP BY `Tahun`
ORDER BY `Tahun` DESC
0.0002 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` NOT LIKE '1.%'
AND `Akun` NOT LIKE '7.%'
GROUP BY `Akun`, `Nama_Akun`
ORDER BY `Akun` ASC
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Tahun` = '2022'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Tahun` = '2022'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `keuangan_manual_rinci`.`Tahun` = '2022'
AND `Kd_Rincian` LIKE '5.%' ESCAPE '!'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT `keuangan_manual_ref_rek3`.`Jenis`, `keuangan_manual_ref_rek3`.`Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '1.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '5.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '6.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '7.%'
AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%'
AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%'
ORDER BY `keuangan_manual_ref_rek3`.`Jenis` ASC
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `jenis_pendapatan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `jenis_pendapatan`
0.0002 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_manual_ref_bidang`
WHERE `Kd_Bid` NOT LIKE '01%'
ORDER BY `Kd_Bid` ASC
0.0001 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2022'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT `setting`
FROM `widget`
WHERE `isi` = 'aparatur_desa.php'
0.0004 sec