ListTable::months_filter should filter order dates by order type

[gedex]

Prerequisites

• I have carried out troubleshooting steps and I believe I have found a bug.
• I have searched for similar bugs in both open and closed issues and cannot find a duplicate.

Describe the bug

This query that list order dates

woocommerce/plugins/woocommerce/src/Internal/Admin/Orders/ListTable.php

Lines 777 to 784 in 821d764

	$order_dates = $wpdb->get_results(
	"
	SELECT DISTINCT YEAR( t.date_created_local ) AS year,
	MONTH( t.date_created_local ) AS month
	FROM ( SELECT DATE_ADD( date_created_gmt, INTERVAL $utc_offset SECOND ) AS date_created_local FROM $orders_table WHERE status != 'trash' ) t
	ORDER BY year DESC, month DESC
	"
	);

is missing a filter of order type. This makes all order types have the same dates dropdown.

Expected behavior

If two order types have different min and max of date_created orders, they should render dates dropdown differently

Actual behavior

Both order types get the same dates dropdown

Steps to reproduce

• Create two test orders with different created months
• Create a subscription (or any order type) with any created month

See the months dropdown are the same:

WordPress Environment

Latest

Isolating the problem

• I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
• This bug happens with a default WordPress theme active, or Storefront.
• I can reproduce this bug consistently using the steps above.