SELECT pd.id, pd.PRODUCTNO, pd.PRODUCT_TEXT, pd.QTY_TOTAL, pd.UOM_TOTAL, pd.last_change, null as Przewoznik, null as Odbiorca, null as Termin, null as Status, null as GrupaMaterialowa, 
				t.TU_NUM_EXT, d.REFDOCNO_ERP, format(t.START_PLAN_TSTFR, 'yyyy/MM/dd HH:mm:ss') as date1, 
				format(d.DL, 'yyyy/MM/dd HH:mm:ss') as date2
				FROM gz_pozycje_dostaw pd
				JOIN gz_dostawy d ON d.id = pd.id_gz_dostawy
				JOIN gz_transporty t ON t.id = d.id_gz_transporty
				JOIN gz_transporty_statusy ts ON ts.id_gz_transporty = t.id
				WHERE t.ACT_DIR = 2 
				AND t.START_PLAN_TSTFR >= '20210107' AND t.START_PLAN_TSTFR <= '20210108'
				ORDER BY t.last_change DESC;
SELECT pd.id, pd.PRODUCTNO, pd.PRODUCT_TEXT, pd.QTY_TOTAL, pd.UOM_TOTAL, pd.last_change, null as Przewoznik, null as Odbiorca, null as Termin, null as Status, null as GrupaMaterialowa, 
				t.TU_NUM_EXT, d.REFDOCNO_ERP, format(t.START_PLAN_TSTFR, 'yyyy/MM/dd HH:mm:ss') as date1, 
				format(d.DL, 'yyyy/MM/dd HH:mm:ss') as date2
				FROM gz_pozycje_dostaw pd
				JOIN gz_dostawy d ON d.id = pd.id_gz_dostawy
				JOIN gz_transporty t ON t.id = d.id_gz_transporty
				JOIN gz_transporty_statusy ts ON ts.id_gz_transporty = t.id
				WHERE t.ACT_DIR = 2 
				AND t.START_PLAN_TSTFR >= '20210119' AND t.START_PLAN_TSTFR <= '20210120'
				ORDER BY t.last_change DESC;
SELECT pd.id, pd.PRODUCTNO, pd.PRODUCT_TEXT, pd.QTY_TOTAL, pd.UOM_TOTAL, pd.last_change, null as Przewoznik, null as Odbiorca, null as Termin, null as Status, null as GrupaMaterialowa, 
				t.TU_NUM_EXT, d.REFDOCNO_ERP, format(t.START_PLAN_TSTFR, 'yyyy/MM/dd HH:mm:ss') as date1, 
				format(d.DL, 'yyyy/MM/dd HH:mm:ss') as date2
				FROM gz_pozycje_dostaw pd
				JOIN gz_dostawy d ON d.id = pd.id_gz_dostawy
				JOIN gz_transporty t ON t.id = d.id_gz_transporty
				JOIN gz_transporty_statusy ts ON ts.id_gz_transporty = t.id
				WHERE t.ACT_DIR = 2 
				AND t.START_PLAN_TSTFR >= '20210120' AND t.START_PLAN_TSTFR <= '20210121'
				ORDER BY t.last_change DESC;
SELECT pd.id, pd.PRODUCTNO, pd.PRODUCT_TEXT, pd.QTY_TOTAL, pd.UOM_TOTAL, pd.last_change, null as Przewoznik, null as Odbiorca, null as Termin, null as Status, null as GrupaMaterialowa, 
				t.TU_NUM_EXT, d.REFDOCNO_ERP, format(t.START_PLAN_TSTFR, 'yyyy/MM/dd HH:mm:ss') as date1, 
				format(d.DL, 'yyyy/MM/dd HH:mm:ss') as date2
				FROM gz_pozycje_dostaw pd
				JOIN gz_dostawy d ON d.id = pd.id_gz_dostawy
				JOIN gz_transporty t ON t.id = d.id_gz_transporty
				JOIN gz_transporty_statusy ts ON ts.id_gz_transporty = t.id
				WHERE t.ACT_DIR = 2 
				AND t.START_PLAN_TSTFR >= '20210120' AND t.START_PLAN_TSTFR <= '20210121'
				ORDER BY t.last_change DESC;