|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'ICU' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'IC' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas VIP'
|
ICU |
IC |
Kelas VIP |
5 |
4 |
0 |
0 |
4 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL1' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL1 |
EDL1 |
Kelas 2 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL2' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL1 |
EDL2 |
Kelas 2 |
2 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL3' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL1 |
EDL3 |
Kelas 2 |
2 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL4' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL1 |
EDL4 |
Kelas 2 |
2 |
1 |
0 |
0 |
1 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL5' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
EDL5 |
Kelas 1 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL6' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
EDL6 |
Kelas 1 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'EDL7' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
EDL7 |
Kelas 1 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'MWR1' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
MWR1 |
Kelas 1 |
2 |
2 |
0 |
2 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'MWR2' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
MWR2 |
Kelas 1 |
2 |
2 |
0 |
2 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'NC1' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
NC1 |
Kelas 1 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'NC2' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
NC2 |
Kelas 1 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'NC3' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
NC3 |
Kelas 1 |
2 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL1' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'NC4' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 1'
|
KL1 |
NC4 |
Kelas 1 |
2 |
1 |
0 |
0 |
1 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL2' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A10' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL2 |
A10 |
Kelas 2 |
2 |
1 |
0 |
0 |
1 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL2' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A11' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL2 |
A11 |
Kelas 2 |
2 |
2 |
0 |
0 |
2 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL2' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A12' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL2 |
A12 |
Kelas 2 |
2 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL2' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A2' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL2 |
A2 |
Kelas 2 |
2 |
1 |
0 |
0 |
1 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL2' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'MWR3' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL2 |
MWR3 |
Kelas 2 |
2 |
1 |
0 |
1 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL2' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'MWR8' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 2'
|
KL2 |
MWR8 |
Kelas 2 |
2 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL3' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A1' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 3'
|
KL3 |
A1 |
Kelas 3 |
3 |
1 |
0 |
0 |
1 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL3' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A3' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 3'
|
KL3 |
A3 |
Kelas 3 |
3 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL3' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A4' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 3'
|
KL3 |
A4 |
Kelas 3 |
3 |
0 |
0 |
0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL3' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A5' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 3'
|
KL3 |
A5 |
Kelas 3 |
3 |
1 |
0 |
0 |
1 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM aplicare_ketersediaan_kamar WHERE `aplicare_ketersediaan_kamar`.`kode_kelas_aplicare` = 'KL3' AND `aplicare_ketersediaan_kamar`.`kd_bangsal` = 'A6' AND `aplicare_ketersediaan_kamar`.`kelas` = 'Kelas 3'
|
KL3 |
A6 |
Kelas 3 |
3 |
0 |
0 |
0 |
0 |