SELECT DISTINCT
                        GET_LBEZNR(T100.LBEZNR, 4) AS CROSS_BRAND,
                        T203.REFNR AS CROSS_ARTNR,
                        T203.DLNR AS CROSS_DLNR,
                        T100.VGL AS OE,
                        IF(T100.VGL = 1, "AFTERMARKET RPODUCT", "OE PRODUCT") AS NOTE

                        FROM `200_fixed` AS P
                        
                        JOIN `203` AS T203 ON T203.ARTNR = P.ARTNR AND T203.DLNR = P.DLNR
                        JOIN `100` AS T100 ON T100.HERNR = T203.KHERNR

                        WHERE P.ARTNR_SHORT = CLEAN_NUMBER("825902")
                        AND (T203.DLNR IN (436))
                        
                        ORDER BY CROSS_BRAND;
                    Array
(
)