First 1000 solo flawless completions of Equilibrium
SELECT row_number() OVER (ORDER BY p.endPlayed ASC) as position, p.pgcrId, p.data.Response as Response FROM pgcr.parsed p WHERE p.referenceId = 2727361621 -- Equilibrium: Normal AND p.completed = 1 AND p.completionReason = 0 AND p.deaths = 0 AND p.activityWasStartedFromBeginning = 1 AND p.playerCount = 1 AND p.activityDurationSeconds > 25*60 AND p.kills > 280 AND (p.pgcrId = 16683984376 OR p.pgcrId >= 16684593689) AND (p.pgcrId not in [16685286031]) ORDER BY p.endPlayed ASC LIMIT 1000