remove debug selects from transaction sql. closes #13