CREATE VIEW vwqueuerealtimedata AS (
 SELECT qc.keyid,
    qc.queueid,
    qd.name AS queuename,
    qc.media,
    qc.statscount,
    qc.startdate,
    qc.startdateltc,
    COALESCE(datediff('second'::text, qc.startdate, timezone('utc'::text, now())), 0) AS statussecs,
    ((datediff('second'::text, qc.startdate, timezone('utc'::text, now())))::numeric / 86400.00) AS statusdays,
    qc.updated
   FROM (queuerealtimedata qc
     LEFT JOIN queuedetails qd ON (((qd.id)::text = (qc.queueid)::text)))
)