As a workaround these can be retrieved with the following SQL:
create temporary table wj select created_at, session from common_eventlog where type="helpim.rooms.waitingroom.joined";
create temporary table wl select created_at, session from common_eventlog where type="helpim.rooms.waitingroom.left";
create temporary table oj select created_at, session from common_eventlog where type="helpim.rooms.one2one.client_joined";
select wj.created_at as wj, wl.created_at as wl, oj.created_at as oj from wj left join wl on wj.session=wl.session left join oj on wj.session = oj.session ;
select min(wj.created_at) as in_wachtrij, max(wl.created_at)-min(wj.created_at) as wachttijd
from wj join wl on wj.session=wl.session
where wj.session not in (select session from oj where oj.session=wj.session) group by wj.session order by min(wj.created_at);
As a workaround these can be retrieved with the following SQL:
create temporary table wj select created_at, session from common_eventlog where type="helpim.rooms.waitingroom.joined"; create temporary table wl select created_at, session from common_eventlog where type="helpim.rooms.waitingroom.left"; create temporary table oj select created_at, session from common_eventlog where type="helpim.rooms.one2one.client_joined";
select wj.created_at as wj, wl.created_at as wl, oj.created_at as oj from wj left join wl on wj.session=wl.session left join oj on wj.session = oj.session ;
select min(wj.created_at) as in_wachtrij, max(wl.created_at)-min(wj.created_at) as wachttijd from wj join wl on wj.session=wl.session where wj.session not in (select session from oj where oj.session=wj.session) group by wj.session order by min(wj.created_at);