stacked-orders.sql

select 
  1 
from 
  deliveries 
where 
  exists (
    select 
      1 
    from 
      deliveries deliveries_2 
    where 
      deliveries.trip_id = deliveries_2.trip_id 
      and deliveries.id != deliveries_2.id 
      and deliveries_2.current = TRUE
  ) 
  and deliveries.current = TRUE 
order by 
  deliveries.created_at desc 
limit 
  50;