Missing argument 2 エラー

WPをバージョンアップさせるとMissing argument 2 エラーが表示され困っています。

function get_name_search_options() {
    global $wpdb;
    
    if (is_search()) {
        global $search_terms, $custom_filters;

        // 現在の検索クエリーに該当する投稿のIDを取得
        $posts = get_posts(array(
            'fields' => 'ids',
            'tax_query' => $taxquerysp,
            'meta_query' => $metaquerysp,
            's' => $search_terms['s'],
            'posts_per_page' => -1
        ));
        
        $rows = $wpdb->get_results( $wpdb->prepare( "
            SELECT m.meta_value AS hoge, m2.meta_value AS hoge_kana, COUNT(m.meta_value) AS cnt FROM wp_postmeta m
            LEFT JOIN wp_postmeta m2 ON m2.post_id = m.post_id
            WHERE 1=1
            AND m.post_id IN (" . join(',', $posts) . ")
            AND m.meta_key = 'hoge' AND m2.meta_key = 'hoge_kana'
            AND m.meta_value != '' AND m2.meta_value != ''
            GROUP BY m.meta_value
            ORDER BY CAST(m2.meta_value AS CHAR)
        " ) );
    } else {
        $rows = $wpdb->get_results( $wpdb->prepare( "
            SELECT m.meta_value AS hoge, m2.meta_value AS hoge_kana, COUNT(m.meta_value) AS cnt FROM wp_postmeta m
            LEFT JOIN wp_postmeta m2 ON m2.post_id = m.post_id
            WHERE 1=1
            AND m.meta_key = 'hoge' AND m2.meta_key = 'hoge_kana'
            AND m.meta_value != '' AND m2.meta_value != ''
            GROUP BY m.meta_value
            ORDER BY CAST(m2.meta_value AS CHAR)
        " ) );
    }
    return $rows;
}

第二引数の設定が必要なのは検索して理解したのですがどのように変更すればいいのか
分かりません。

どなたか教えて頂けないでしょうか？