Query MySQL

select
    e.employee_number_formatted `ID`,
    e.name `Nama`,
    c.contract_type `Contract Type`,
    e.date_of_birth `Tgl. Lahir`,
    c.payroll_period `Payroll Period`,
    c.base_salary `Gaji Pokok`,
    c.lembur_type `Tipe Lembur`,
    c.lembur_index `Index Lembur`,
    c.allowance_json `Tunjangan`,
    c.allowance_extra_json `Tunjangan Extra`,

    c.enabled_salary_site `Gaji Site Aktif ?`,
    c.base_salary_site `Gaji Pokok Site`,
    c.allowance_site_json `Tunjangan di Site`,
    c.allowance_site_standby_json `Tunjuangan Standby Site`
from contract as c
left join employee as e on c.employee_id = e.id
where
    c.end_date > now() and
    c.is_approved = 1 and
    c.is_confirmed = 1 and
    c.is_rejected = 0 and
    c.is_terminated = 0 and
    c.cache_is_terminated = 0;
;