Query Override Khusus Admin

-- Query Konfig KOTA

select
    k.nama,
    mk.keterangan,
    kk.value_real
from
    konfig_kota kk
join kota k on
    k.kota_id = kk.kota_id
join m_konfig mk on
    mk.k_konfig = kk.k_konfig
where
    kk.k_konfig in (1901, 1902, 1903)
    and LENGTH(TRIM(kk.value_real)) > 0
    and kk.k_zona = 3;

-- Query Konfig Jenjang

SELECT
  k.nama,
  mk.keterangan,
  COALESCE(
    JSON_UNQUOTE(JSON_EXTRACT(kk.value_real, '$[0][0]')),
    '0'
  ) AS k_jalur,
  kj.value_real AS value_real_konfig
FROM konfig_jenjang kj
JOIN kota k
  ON k.kota_id = kj.kota_id
JOIN m_konfig mk
  ON mk.k_konfig = kj.k_konfig
LEFT JOIN konfig_kota kk
  ON kk.k_konfig = '1005'
 AND kk.kota_id  = k.kota_id
 AND kk.k_zona   = kj.k_zona
WHERE
  kj.k_konfig    = 3902
  AND LENGTH(TRIM(kj.value_real)) > 0
  AND kj.k_zona   = 3;