media: get_streams

Custom SQL query returning 60 rows (hide)

SELECT
  s.id, s.v_uid, s.source, s.sourceUrl, s.embedUrl, s.proxyUrl,
  s.directLink, s.kind, s.addedAt,
  v.code, v.titleEn, v.jacketThumbUrl
FROM streams s
JOIN videos v ON v.uid = s.v_uid
WHERE (:source = '' OR s.source = :source)
  AND (:kind   = '' OR s.kind   = :kind)
ORDER BY s.id DESC
LIMIT  CAST(COALESCE(NULLIF(:limit,  ''), 60) AS INTEGER)
OFFSET CAST(COALESCE(NULLIF(:offset, ''), 0)  AS INTEGER)

Query parameters

source

kind

limit

offset