better_query2.sql

SELECT
   * 
FROM
   orders 
   JOIN
      order_allocations 
      ON orders.id = order_allocations.order_id 
WHERE
   orders.completed_at > date(now()) 
   AND order_allocations.client_id = 'A' 
   AND order_allocations.order_id > :yesterdaysId