removed subscription tables and sprocs
hooked up query endpoint