new test and verify
Implemented db output with tests in query, offlineupdatewid, and offlinegetwid
query debug implemented
Merged with Joes latest