direct SQL queries and a couple of tests