- my $query = $dbh->prepare(q{SELECT r.id,released_coords AS releasedcoords,tick,waves*COUNT(DISTINCT rt.id) AS waves,
- COUNT(rc.uid) AS claims, COUNT(nullif(rc.launched,false)) AS launched,COUNT(NULLIF(rc.uid > 0,true)) AS blocked
+ my $query = $dbh->prepare(q{
+ SELECT r.id,released_coords AS releasedcoords,tick
+ ,waves*COUNT(DISTINCT rt.id) AS waves,COUNT(rc.uid) AS claims
+ ,COUNT(nullif(rc.launched,false)) AS launched
+ ,COUNT(NULLIF(rc.uid > 0 OR rc.wave > r.waves,true)) AS blocked