cleaned up sql formatting, added print statements to check performance.
trying to bisect
fixed a janus C-a blunder, need to disable that.
logging to stdout
added some descriptive logging to stdout
first crack at consolidation integration test