UI improvements and fix - make sql portable - bring all sql inline - reduce query duplication - simplify if idioms - fix UI by unclobbering revision_id variable and allowing to select revision correctly
Improvement and fixes for this UI - improve localization - exploit builtin multirow feature - reduce divergencies between oracle and postgres codebase - remove unused sql columns - invert boolean logics for approved and live to reflect sql clause behavior