c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception

错误：

2024-09-04 19:31:38.286  WARN 9224 --- [  XNIO-1 task-1] c.b.m.e.p.i.PaginationInnerInterceptor   : optimize this sql to a count sql has exception, sql:"select
            b.userid,
            b.promoterid,
            b.remark,
            b.created_by,
            b.created_at,
            b.updated_by,
            b.updated_at,
            b.delete,
            u.channel,
            u.platformid,
            u.username,
            u.nickname,
            pu.username as pusername,
            u.level as level,
            lev.name as levelName,
            c.amount,
            c.currencytype AS currencytype,
            game.agentMoney as goldBankSurplus,
            ord.deposit_amount as depositAmount,
            ord.withdraw_count as withdrawCount,
            pro.dan as vip,
            ur.main_vbet,
            ur.main_win,
            ur.main_charge,

            ur.ab_vbet,
            ur.third_vbet,
            ur.item_cost,
            ur.insurance_rec,
            ur.ab_win,
            ur.third_win,
            ur.total_dividend,
            ur.total_back_water,

            u.registerip,
            u.deposittime as deposittime,
            u.lastlogintime as lastlogintime,
            u.lastloginip as lastloginip,
            u.registertime as registertime
        from info_promoter_user_bind b
        left join info_user u on u.userid = b.userid
        left join info_user pu on pu.userid = b.promoterid
        left join info_order_user ord ON
             b.userid = ord.user_id
        LEFT JOIN info_user_currency c ON b.userid = c.userid
        left join info_agent_game_user game on b.userid= game.userid
        left join info_user_properties pro ON b.userid = pro.userid
        left join  cfg_user_level  lev  on (u.level = lev.level and lev.platformid = u.platformid)
        left join (
            SELECT
            userid, sum(main_charge) as main_charge, sum(main_vbet) as main_vbet, sum(main_win) as main_win
        ,sum(ab_vbet) as ab_vbet ,sum(third_vbet) as third_vbet ,sum(item_cost) as item_cost ,sum(insurance_rec) as insurance_rec ,sum(ab_win) as ab_win
        ,sum(third_win) as third_win ,sum(total_dividend) as total_dividend ,sum(total_back_water) as total_back_water
            FROM
             
                    game_center_bi_dev.bi_user_report bi
                 
             GROUP BY userid
        ) ur
        ON b.userid = ur.userid
         WHERE  b.promoterid in
                (
                    ?
                ) 
        order by b.created_at desc", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "." "."
    at line 9, column 14.

Was expecting one of:

    "&"
    "::"
    ";"
    "<<"
    ">>"
    "ACTION"
    "ACTIVE"
    "ALGORITHM"
    "ARCHIVE"
    "ARRAY"
    "AS"
    "AT"
    "BYTE"
    "CASCADE"
    "CASE"
    "CAST"
    "CHANGE"
    "CHAR"
    "CHARACTER"
    "CHECKPOINT"
    "COLLATE"
    "COLUMN"
    "COLUMNS"
    "COMMENT"
    "COMMIT"
    "CONNECT"
    "COSTS"
    "CYCLE"
    "DBA_RECYCLEBIN"
    "DEFAULT"
    "DESC"
    "DESCRIBE"
    "DISABLE"
    "DISCONNECT"
    "DIV"
    "DO"
    "DUMP"
    "DUPLICATE"
    "EMIT"
    "ENABLE"
    "END"
    "EXCLUDE"
    "EXTRACT"
    "FALSE"
    "FILTER"
    "FIRST"
    "FLUSH"
    "FN"
    "FOLLOWING"
    "FORMAT"
    "FULLTEXT"
    "GROUP"
    "HAVING"
    "HISTORY"
    "INDEX"
    "INSERT"
    "INTERVAL"
    "INTO"
    "ISNULL"
    "JSON"
    "KEY"
    "LAST"
    "LEADING"
    "LINK"
    "LOCAL"
    "LOG"
    "MATERIALIZED"
    "NO"
    "NOLOCK"
    "NULLS"
    "OF"
    "OPEN"
    "OVER"
    "PARALLEL"
    "PARTITION"
    "PATH"
    "PERCENT"
    "PRECISION"
    "PRIMARY"
    "PRIOR"
    "QUERY"
    "QUIESCE"
    "RANGE"
    "READ"
    "RECYCLEBIN"
    "REGISTER"
    "REPLACE"
    "RESTRICTED"
    "RESUME"
    "ROW"
    "ROWS"
    "SCHEMA"
    "SEPARATOR"
    "SEQUENCE"
    "SESSION"
    "SHUTDOWN"
    "SIBLINGS"
    "SIGNED"
    "SIZE"
    "SKIP"
    "START"
    "SUSPEND"
    "SWITCH"
    "SYNONYM"
    "SYSTEM"
    "TABLE"
    "TABLESPACE"
    "TEMP"
    "TEMPORARY"
    "TIMEOUT"
    "TO"
    "TOP"
    "TRUE"
    "TRUNCATE"
    "TRY_CAST"
    "TYPE"
    "UNQIESCE"
    "UNSIGNED"
    "USER"
    "VALIDATE"
    "VALUE"
    "VALUES"
    "VIEW"
    "WINDOW"
    "XML"
    "ZONE"
    "["
    "^"
    "|"
    <EOF>
    <K_DATETIMELITERAL>
    <K_DATE_LITERAL>
    <K_NEXTVAL>
    <K_STRING_FUNCTION_NAME>
    <S_CHAR_LITERAL>
    <S_IDENTIFIER>
    <S_QUOTED_IDENTIFIER>

原因：MybatisPlus 优化sql计数器 报的错误，sql可以正常执行，不用理会！