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("5961.308.371")
                        AND (T203.DLNR IN (68))
                        
                        ORDER BY CROSS_BRAND;
                    Array
(
    [0] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => 001 989 68 03
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [1] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => 007 603 01 01 00
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [2] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => 140 271 00 60
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [3] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => 140 271 00 80
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [4] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => 140 277 00 95
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [5] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => A 001 989 68 03
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [6] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => A 140 271 00 60
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [7] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => A 140 271 00 80
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [8] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => A 140 277 00 95
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [9] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ
            [CROSS_ARTNR] => N 007 603 01 01 00
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [10] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ (BBDC)
            [CROSS_ARTNR] => 140 277 00 95
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [11] => stdClass Object
        (
            [CROSS_BRAND] => MERCEDES-BENZ (BBDC)
            [CROSS_ARTNR] => A 140 277 00 95
            [CROSS_DLNR] => 68
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [12] => stdClass Object
        (
            [CROSS_BRAND] => MEYLE
            [CROSS_ARTNR] => 014 135 0201
            [CROSS_DLNR] => 68
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [13] => stdClass Object
        (
            [CROSS_BRAND] => VAICO
            [CROSS_ARTNR] => V30-2254
            [CROSS_DLNR] => 68
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

)