SELECT o.order_id as order_id,
       oi.NAME as nama_produk,
       o.quantity as order_qty,
       sch.NAME as nama_sekolah,
       sch.address as alamat_sekolah,
       sch.city as kota_sekolah,
       sch.province as provinsi_sekolah,
       sch.zip_code as kode_pos_sekolah,
       sch.npsn as npsn,
       sch.phone as telepon_sekolah,
       sch.npwp as npwp_sekolah,
       sch.email as email_sekolah,
       cust.NAME as pic_sekolah,
       cust.npwp as pic_npwp,
       cust.phone as telepon_pic,
       o.amount as amount,
       (coalesce('NULL')) as no_so_dropship,
       (coalesce('NULL')) as no_po_dropship,
       o.status,
       o.payment_status
FROM   order_items oi
       INNER JOIN orders o
               ON o.order_id = oi.order_id
       INNER JOIN users cust
               ON o.customer_id = cust.id
       INNER JOIN schools sch
               ON sch.id = cust.school_id
WHERE  o.merchant_id = 'STGL-0003'
ORDER BY o.created_date asc