amy-mac

# All Dec 18th matches
Matches = Match.where("published_at >= ?", “12-18-2017”).reject { |m| m.user.deleted? || m.friend.deleted? }

# Filtered by the matches who haven’t seen their match:
matches.where(seen_at: nil)

# Filtered by the matches who have seen their match but didn’t message
matches.where(“seen_at IS NOT NULL”).reject { |m| m.all_messages.exists? }

amy-mac

                                                                 
#     ,o888888o.     8 8888      88  8 8888  8888888888',8888' 
#  . 8888     `88.   8 8888      88  8 8888         ,8',8888'  
# ,8 8888       `8b  8 8888      88  8 8888        ,8',8888'   
# 88 8888        `8b 8 8888      88  8 8888       ,8',8888'    
# 88 8888         88 8 8888      88  8 8888      ,8',8888'     
# 88 8888     `8. 88 8 8888      88  8 8888     ,8',8888'      
# 88 8888      `8,8P 8 8888      88  8 8888    ,8',8888'       
# `8 8888       ;8P  ` 8888     ,8P  8 8888   ,8',8888'        
#  ` 8888     ,88'8.   8888   ,d8P   8 8888  ,8',8888'