home / media

media: get_video_streams

Custom SQL query (hide)

SELECT
  s.id,
  s.v_uid,
  s.source,
  s.sourceUrl,
  s.embedUrl,
  s.proxyUrl,
  s.directLink,
  s.kind,
  s.addedAt
FROM streams s
WHERE s.v_uid = :v_uid
ORDER BY
  -- A direct media URL first: it plays without a third-party page, so
  -- a client walking the list in order tries the best option first.
  (s.directLink IS NULL), s.source, s.id

Query parameters

0 results

Powered by Datasette · Queries took 0.362ms