Column missing from export

Hi, we met the problem of version 0.41 about column missing while export csv or excel. After we apply the patch of https://github.com/metabase/metabase/pull/18441, we test that it can fix the case you have given.
We also find other case still suffer from column missing, looks like when invoke table join. But unfortunately we can't reproduce it in sampleSet.
The query dataset_query is:

{
    "type": "query",
    "query": {
        "source-table": 112,
        "filter": [
            "=",
            [
                "field-id",
                538039
            ],
            1
        ],
        "joins": [
            {
                "fields": [
                    [
                        "joined-field",
                        "dim_table_bss_product_biz",
                        [
                            "field-id",
                            570
                        ]
                    ]
                ],
                "source-table": 69,
                "condition": [
                    "=",
                    [
                        "field-id",
                        74949
                    ],
                    [
                        "joined-field",
                        "dim_table_bss_product_biz",
                        [
                            "field-id",
                            572
                        ]
                    ]
                ],
                "alias": "dim_table_bss_product_biz"
            }
        ],
        "order-by": [
            [
                "asc",
                [
                    "joined-field",
                    "dim_table_bss_product_biz",
                    [
                        "field-id",
                        570
                    ]
                ]
            ]
        ],
        "fields": [
            [
                "field-id",
                569
            ],
            [
                "field-id",
                567
            ]
        ]
    },
    "database": 2
}

The visualization_settings is:

{
    "table.pivot_column": "name_2",
    "table.cell_column": "name",
    "table.columns": [
        {
            "name": "name_2",
            "fieldRef": [
                "joined-field",
                "dim_table_bss_product_biz",
                [
                    "field-id",
                    570
                ]
            ],
            "enabled": true
        },
        {
            "name": "id",
            "field_ref": [
                "field-id",
                569
            ],
            "enabled": true
        },
        {
            "name": "name",
            "fieldRef": [
                "field-id",
                567
            ],
            "enabled": true
        }
    ],
    "column_settings": {
        "[\"ref\",[\"field-id\",570]]": {
            "column_title": "业务"
        },
        "[\"ref\",[\"field-id\",567]]": {
            "column_title": "付费产品"
        },
        "[\"ref\",[\"field-id\",569]]": {
            "column_title": "付费产品ID"
        }
    }
}

The case above, when export, column of field-id=569 is missing
Any tips?

Hi @KEN-LJQ
I can see it's an old question because it uses the old field dimensions. But let me see if I can reproduce this, since you have provided enough metadata - thank you for that.

@KEN-LJQ Reproduced and we're writing a test for it in a couple of hours and then a fix - follow:
https://github.com/metabase/metabase/issues/18382

Excited to hear that, metabase is so powerful, thanks your guys make this impressive product