bwj_server/src/dsb/com/cnd3b/restcontroller/customer/live/SQL/直播场次列表查询.sql

SELECT t1.sessionid,
       t1.description,
       DATEADD(S, convert(float,t1.starttime) / 1000, '1970-01-01 08:00:00') as starttime,
       t1.liveuv,
       t1.livepv,
       t1.duration
FROM tlive_sessiondata AS t1
WHERE t1.channelid = $channelid$