SELECT DISTINCT
                        GET_LBEZNR(T100.LBEZNR, 48) 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("8126129")
                        AND (T203.DLNR IN (175))
                        
                        ORDER BY CROSS_BRAND;
                    Array
(
    [0] => stdClass Object
        (
            [CROSS_BRAND] => FEBI BILSTEIN
            [CROSS_ARTNR] => 28040
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [1] => stdClass Object
        (
            [CROSS_BRAND] => FIAT
            [CROSS_ARTNR] => 46514867
            [CROSS_DLNR] => 175
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [2] => stdClass Object
        (
            [CROSS_BRAND] => FIAT
            [CROSS_ARTNR] => 51794446
            [CROSS_DLNR] => 175
            [OE] => 0
            [NOTE] => OE PRODUCT
        )

    [3] => stdClass Object
        (
            [CROSS_BRAND] => MONROE
            [CROSS_ARTNR] => ML5377
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [4] => stdClass Object
        (
            [CROSS_BRAND] => QUINTON HAZELL
            [CROSS_ARTNR] => 128524
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [5] => stdClass Object
        (
            [CROSS_BRAND] => STABILUS
            [CROSS_ARTNR] => 5037SY
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [6] => stdClass Object
        (
            [CROSS_BRAND] => STABILUS
            [CROSS_ARTNR] => 5044SG
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [7] => stdClass Object
        (
            [CROSS_BRAND] => STABILUS
            [CROSS_ARTNR] => 5081XE
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [8] => stdClass Object
        (
            [CROSS_BRAND] => SWAG
            [CROSS_ARTNR] => 70928040
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

    [9] => stdClass Object
        (
            [CROSS_BRAND] => TRISCAN
            [CROSS_ARTNR] => 8710-15218
            [CROSS_DLNR] => 175
            [OE] => 1
            [NOTE] => AFTERMARKET RPODUCT
        )

)