Here is a simplified version of the query:

Fetching Last 24 Hour Records Using Unix Timestamps in MySQL

How to Retrieve Unique Data Across Multiple Columns with MySQL's ROW_NUMBER() Function

Understanding Table Relationships in MySQL and Rails: A Comprehensive Guide to Establishing Direct and Many-to-Many Connections Between Tables.

How to Combine Multiple Select Statements into a Single Query Using Subqueries, CTEs, and Conditional Logic

Understanding the Role of COLUMN Keyword in MySQL Alter Table Statements

Resolving the `Mysql2::Error: MySQL client is not connected` Issue in Rails Applications

How to Use COUNT(DISTINCT...) with Subqueries in SQL Without Errors

Understanding SQL Slowdown in Python: A Deep Dive into Query Optimization Strategies

How to Keep Only the Row with the Highest Value for a Specific Data Field in MySQL