SQL Query Optimizer and Explainer

Optimize this SQL query for performance:
[paste query here]

Analysis steps:
1. Identify the query type (SELECT/INSERT/UPDATE/DELETE)
2. Check for common anti-patterns:
   - SELECT * instead of specific columns
   - Missing WHERE clause indexes
   - N+1 via correlated subqueries (convert to JOIN)
   - OR conditions preventing index usage (convert to UNION)
   - LIKE '%prefix' preventing index usage
   - Implicit type conversions in WHERE clause
   - Unnecessary DISTINCT or ORDER BY
   - Large OFFSET pagination (use keyset pagination instead)
3. Suggest CREATE INDEX statements with column order reasoning
4. Rewrite the query if structural changes improve performance
5. If EXPLAIN ANALYZE output is provided, interpret the plan:
   - Identify sequential scans that should be index scans
   - Find the most expensive node
   - Check estimated vs actual row counts for cardinality issues
6. Show before/after query and expected improvement