🔍 DEBUGGING COHORT MATCHING ISSUE
Event ID: 240721
============================================================

1️⃣ CURRENT EVENT FEATURES
------------------------------
Event ID: 240721
Venue ID: 63865
Weekday: Saturday
Time Bucket: late_night
Start Time: 2025-10-25 22:30:00
Holiday Flag: 0

2️⃣ COHORT QUERY TEST
------------------------------
Query:    SELECT DISTINCT     ef.*,     COALESCE(ea.final_attendance, 0) as final_attendance,     COALESCE(ea.final_revenue, 0) as final_revenue   FROM wp_coco_event_features ef   LEFT JOIN wp_coco_event_actuals ea ON ef.event_id = ea.event_id   LEFT JOIN wp_coco_event_snapshots es ON ef.event_id = es.event_id   WHERE ef.event_id != %d AND ef.venue_id = %s AND ef.weekday = %s AND ef.start_bucket IN (%s,%s) AND ef.holiday_flag = %d AND ef.start_ts < NOW()   ORDER BY ef.start_ts DESC   LIMIT 20 
Params: 240721, 63865, Saturday, late_night, night, 0

Cohorts found: 20

Cohort Events:
  1. 2025-11-01 22:30:00 - ✅ PAST
  2. 2025-10-11 22:30:00 - ✅ PAST
  3. 2025-10-04 22:30:00 - ✅ PAST
  4. 2025-09-27 22:30:00 - ✅ PAST
  5. 2025-09-20 22:30:00 - ✅ PAST
  6. 2025-09-13 22:30:00 - ✅ PAST
  7. 2025-09-06 22:30:00 - ✅ PAST
  8. 2025-08-30 22:30:00 - ✅ PAST
  9. 2025-08-23 22:30:00 - ✅ PAST
  10. 2025-08-16 22:30:00 - ✅ PAST
  11. 2025-08-09 22:30:00 - ✅ PAST
  12. 2025-08-02 22:30:00 - ✅ PAST
  13. 2025-07-26 22:30:00 - ✅ PAST
  14. 2025-07-19 22:30:00 - ✅ PAST
  15. 2025-07-19 01:04:00 - ✅ PAST
  16. 2025-07-12 22:30:00 - ✅ PAST
  17. 2025-07-05 22:30:00 - ✅ PAST
  18. 2025-06-28 22:30:00 - ✅ PAST
  19. 2025-06-21 22:30:00 - ✅ PAST
  20. 2025-06-14 22:30:00 - ✅ PAST

3️⃣ CHECKING FOR PAST EVENTS
------------------------------
Past events found: 10
  • TWNTY7 - Let's Get LIT Saturdays (2025-11-01 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-10-11 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays Independence Edition (2025-10-04 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-09-27 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-09-20 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-09-13 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-09-06 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-08-30 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-08-23 22:30:00)
  • TWNTY7 - Grown & Sexy Saturdays (2025-08-16 22:30:00)

4️⃣ TIME COMPARISON
------------------------------
Current time: 2025-11-05 03:48:51
Event time: 2025-10-25 22:30:00
Event is in past: Yes

✅ Debug complete.