

select * from (select * from group)
/**
output()
match(fullname,"/admin")
**/
;


select * from (select class,id,username,lft,rgt from ldap)
/**
output()
match(username,"/")
match(username,"admin")
**/
;

select avg(lft) as a,avg(rgt) as b from(select class,id,username,lft,rgt from ldap)
/**
output()
match(a,1.5,b,3.5)
**/
;

select avg(x.lft) as a,avg(rgt) as b from(select class,id,username,lft,rgt from ldap) x
/**
output()
match(a,1.5,b,3.5)
**/
;
