WP_QUERY将数字排序为字母

我在使用ACF插件创建的用户配置文件中有一些meta\\u字段。我正在尝试运行查询以获取具有以下条件的用户：

用户必须具有meta\\u字段jogador_profissional == truequantidade_corretas (ASC) 以及tempo_total (DESC). 两者都是数值



    $args = array(
        "fields" => "ids",
        "meta_key" => "jogador_oficial",
        "meta_value" => true,
        "meta_query" => array(
        
            "relation" => "AND",
            "query_one" => array(
                "key" => "quantidade_corretas"
            ),
            "query_two" => array(
                "key" => "tempo_total"
            ),
        ),
        "orderby" => array(
            "query_one" => "DESC",
            "query_two" => "ASC"
        ),

    );

    $user_query = new WP_User_Query($args);

    $users = $user_query->get_results();

它运行正常，但我怀疑此查询将数值视为字符串值：例如，9 > 100 或2 > 18.

使此订单以数字方式工作，我做错了什么？

谢谢

$args = array( "fields" => "ids", "meta_key" => "jogador_oficial", "meta_value" => true, "meta_query" => array( "relation" => "AND", "query_one" => array( "key" => "quantidade_corretas" "orderby" => "meta_value_num", "order" => "DESC" ), "query_two" => array( "key" => "tempo_total" "orderby" => "meta_value_num", "order" => "ASC" ), ), );

MySQL更新MENU_ORDER问题

如果post\\u类型产品没有缩略图，我正在尝试更新menu\\u顺序。。。已尝试：UPDATE phiz_posts SET menu_order = 1 WHERE ID IN (SELECT ID FROM phiz_posts LEFT JOIN phiz_postmeta ON phiz_posts.ID = phiz_postmeta.post_id AND phiz_postmeta.meta_key = \'_thumbnail_id\' WHERE post_type=\'product

相关推荐

MySQL更新MENU_ORDER问题