Query Stock

$query = $this->db->query('SELECT id_product
                FROM _stock_awal
                WHERE DATE(date) = "'.$date_last_so.'"
                AND id_branch = '.$id_branch.'
                UNION
                SELECT intid_barang
                FROM nota JOIN nota_detail ON nota.intid_nota = nota_detail.intid_nota
                WHERE intid_cabang = '.$id_branch.'
                AND datetgl >= "'.$date_last_so.'"
                AND datetgl <= "'.$end_date.'"
                UNION
                SELECT intid_barang
                FROM nota_hadiah JOIN nota_detail_hadiah ON nota_hadiah.intid_nota = nota_detail_hadiah.intid_nota
                WHERE intid_cabang = '.$id_branch.'
                AND datetgl >= "'.$date_last_so.'"
                AND datetgl <= "'.$end_date.'"
                UNION
                SELECT intid_barang
                FROM po_ JOIN po_detail_ ON po_.no_po = po_detail_.no_po
                WHERE intid_cabang = '.$id_branch.'
                AND time >= "'.$date_last_so.'"
                AND time <= "'.$end_date.'"
                UNION
                SELECT intid_barang
                FROM spkb JOIN spkb_detail ON spkb.no_spkb = spkb_detail.no_spkb
                WHERE intid_cabang = '.$id_branch.'
                AND (tgl_order >= "'.$date_last_so.'"
                AND tgl_order <= "'.$end_date.'")
                OR (tgl_kirim >= "'.$date_last_so.'"
                AND tgl_kirim <= "'.$end_date.'")
                OR (tgl_terima >= "'.$date_last_so.'"
                AND tgl_terima <= "'.$end_date.'")
                UNION
                SELECT intid_barang
                FROM komplain JOIN komplain_detail ON komplain.no = komplain_detail.no
                WHERE intid_cabang = '.$id_branch.'
                AND date_added >= "'.$date_last_so.'"
                AND date_added <= "'.$end_date.'"
                UNION
                SELECT intid_barang
                FROM retur_ JOIN retur_detail_ ON retur_.no_srb = retur_detail_.no_srb
                WHERE intid_cabang = '.$id_branch.'
                AND (datetgl >= "'.$date_last_so.'"
                AND datetgl <= "'.$end_date.'")
                OR (date_verified >= "'.$date_last_so.'"
                AND date_verified <= "'.$end_date.'")
                UNION
                SELECT intid_barang
                FROM sttb JOIN sttb_detail ON sttb.no_sttb = sttb_detail.no_sttb
                WHERE intid_cabang = '.$id_branch.'
                AND (waktu >= "'.$date_last_so.'"
                AND waktu <= "'.$end_date.'")
                OR (tgl_order >= "'.$date_last_so.'"
                AND tgl_order <= "'.$end_date.'")
                OR (tgl_kirim >= "'.$date_last_so.'"
                AND tgl_kirim <= "'.$end_date.'")
                UNION
                SELECT intid_barang
                FROM retur_sparepart JOIN retur_sparepart_detail ON retur_sparepart.intid_retur_sparepart = retur_sparepart_detail.intid_retur_sparepart
                WHERE intid_cabang = '.$id_branch.'
                AND datetgl >= "'.$date_last_so.'"
                AND datetgl <= "'.$end_date.'"
                UNION
                SELECT intid_barang
                FROM pra_sttb_sparepart JOIN pra_sttb_sparepart_detail ON pra_sttb_sparepart.no = pra_sttb_sparepart_detail.no
                WHERE intid_cabang = '.$id_branch.'
                AND waktu >= "'.$date_last_so.'"
                AND waktu <= "'.$end_date.'"
                UNION
                SELECT intid_barang
                FROM sttb_sparepart JOIN sttb_sparepart_detail ON sttb_sparepart.no_sttb = sttb_sparepart_detail.no
                WHERE intid_cabang = '.$id_branch.'
                AND waktu >= "'.$date_last_so.'"
                AND waktu <= "'.$end_date.'"
                ');