clean up sqls
implement unapplied eabax applications