MySql Select Query Optimization

My project revolves around a MySQL select query that is showing slower-than-desired execution times. I cannot provide the data as it has PII and is very large. Main issue is that for pulling 1 month of data it takes about 3 hours, regardless if it returns 500 rows or 500,000 rows. There is likely a required index that I cannot see.

I will be providing
1) The query
2) The Explain Tree
3) The table definition from which it is pulling data.