Marketpress V 126.96.36.199
If orders are trashed in Manage Orders they are still being included in the dashboard stats. Trashed orders are typically never fulfilled. Hence, the query should include a filter for excluding them in the stats.
I added this to each query WHERE clause:
'AND p.post_status != 'trash'`