Note - There are about 2-3 million records in the db. 

```
SELECT     
   route_date, stop_exception_code, unique_id_no, 
   customer_reference, stop_name, stop_comment,
   branch_id, customer_no, stop_expected_pieces, 
    datetime_updated, updated_by, route_code
FROM
   cops_reporting.distribution_stop_information distribution_stop_information
WHERE     
   (stop_exception_code <> 'null') AND 
   (datetime_updated >= { ts '2011-01-25 00:00:01' })
ORDER BY datetime_updated DESC

```