SELECT DISTINCT 
                    T050.KRITNR AS ID_CRY,
                    IFNULL(GET_BEZNR(T050.BEZNR, 48), "") AS NAME_CRY,						
                    IF(T050.TYP <> "K", 
                        T210.KRITWERT, 
                        IFNULL(GET_BEZNR_FOR_KEY_TABLE(T050.TABNR, T210.KRITWERT, 48), "")
                        ) AS VALUE_CRY

                    FROM `200_fixed` AS P		
                        JOIN `200` AS T200 ON T200.ARTNR = P.ARTNR AND T200.DLNR = P.DLNR
                        JOIN `210` AS T210 ON T210.ARTNR = T200.ARTNR AND T210.DLNR = T200.DLNR
                        JOIN `050` AS T050 ON T050.DLNR IN (T200.DLNR, 9999) AND T050.KRITNR = T210.KRITNR
                    WHERE P.ARTNR_SHORT = "XA50205" AND EXISTS (SELECT 1 FROM `001` T001 WHERE T001.DLNR = P.DLNR AND T001.KHERNR = "3726")