SELECT
MKO.IPTDAT_0 as 'Date Imputation',
substring(convert(varchar(4),YEAR(MKO.IPTDAT_0)),3,2) + CASE
WHEN DATEPART(WK,MKO.IPTDAT_0)<10 then '0'+CAST(DATEPART(WK,MKO.IPTDAT_0) AS VARCHAR(1))
WHEN DATEPART(WK,MKO.IPTDAT_0)>=10 then CAST(DATEPART(WK,MKO.IPTDAT_0) AS VARCHAR(2))
END as 'Semaine Saisie',
ITM.TCLCOD_0 as 'Catégorie',
ITM.TSICOD_0 as 'BU',
COALESCE(AX1.TEXTE_0, 'Non Renseigné') as 'Famille Stat 2',
COALESCE(AX2.TEXTE_0,'Non Renseigné') as 'Famille Stat 3',
COALESCE(AX3.TEXTE_0, 'non Renseigné') as 'Famille Stat 4',
COALESCE(AX4.TEXTE_0, 'Non Renseigné') as 'Famille Stat 5'
FROM MFGOPETRK MKO
INNER JOIN MFGITM MFI ON MKO.MFGNUM_0 = MFI.MFGNUM_0
INNER JOIN MFGOPE MFO ON MKO.MFGNUM_0 = MFO.MFGNUM_0 AND MKO.OPENUM_0 = MFO.OPENUM_0 AND MKO.OPESPLNUM_0 = MFO.OPESPLNUM_0
LEFT OUTER JOIN WORKSTATIO WRK ON MKO.CPLWST_0 = WRK.WST_0 AND MKO.MFGFCY_0 = WRK.WCRFCY_0
WHERE
MKO.IPTDAT_0 >= {ts '2014-01-01 00:00:00'}