SELECT DISTINCT
                        GET_LBEZNR(T100.LBEZNR, 4) AS CROSS_BRAND,
                        
                        T203.REFNR AS CROSS_ARTNR,
            
                        T203.DLNR    AS MY_DLNR,        -- DLNR вашего товара
                        T203.KHERNR  AS CROSS_HERNR,    -- HERNR бренда аналога
                        T001.DLNR    AS CROSS_DLNR,     -- ← правильный 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

                        LEFT JOIN `001` AS T001 ON T001.KHERNR = T203.KHERNR

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