query.select().column("t", "subj");
query.select().append("CASE WHEN su.value IS NOT NULL THEN su.value WHEN slu.value IS NOT NULL THEN slu.value ELSE sb.value END");
query.select().column("pu", "id");
query.select().column("pu", "value");
query.select().column("t", "obj");
query.select().append("CASE WHEN ou.value IS NOT NULL THEN ou.value" +
" WHEN olu.value IS NOT NULL THEN olu.value" +
" WHEN ob.value IS NOT NULL THEN ob.value" +
" WHEN ol.value IS NOT NULL THEN ol.value ELSE oll.value END");
query.select().column("od", "value");
query.select().column("og", "value");