Александр

$order_ids_approved = $wpdb->get_results( "SELECT `ID` FROM `avt_posts` WHERE `post_status` = 'wc-approved' AND (`post_date` BETWEEN '{$start_day}' AND '{$end_day}')", ARRAY_A );

$count = $wpdb->get_var( "SELECT count(*) FROM `avt_posts` WHERE `post_type` = 'shop_order'" );
echo $count;