SELECT DISTINCT 
    GET_LBEZNR(T100.LBEZNR, 48) AS CROSS_BRAND,
    CR.REFNRSHORT AS CROSS_ARTNR,
    CR.DLNR AS CROSS_DLNR,
    T100.VGL AS OE
    
FROM `200_fixed` AS P
JOIN `203_fixed` AS CR ON CR.ARTNR = P.ARTNR AND CR.DLNR = P.DLNR
JOIN `100` AS T100 ON T100.HERNR = CR.KHERNR
WHERE P.ARTNR_SHORT = CLEAN_NUMBER('0002950050')
AND CR.KHERNR IN (74)
ORDER BY CROSS_BRAND;Array
(
)