SELECT * FROM bakery.bakery_ikg_single_info WHERE status IN ('enroute','scheduled') AND recieving_facility IN(7,9,10) order by created_date DESC

Please log out when finished.
Route title
Route id
Date Reported
Date Serviced 
Facility
Driver
Default Data View  

Candy/Pet Food/Mayo Routes

Route Id Status Title Facility Created By Scheduled Driver Sub Hauler Stops Inc. Expected Collected