media: get_series

Custom SQL query returning 60 rows (hide)

SELECT s.uid, s.name, s.nameJa,
       (SELECT count(*) FROM videos v WHERE v.s_uid = s.uid) AS videoCount
FROM series s
WHERE :q = '' OR lower(s.name) LIKE '%' || lower(:q) || '%'
ORDER BY
  CASE WHEN :sort = 'name' AND :order = 'asc'  THEN s.name END ASC,
  CASE WHEN :sort = 'name' AND :order = 'desc' THEN s.name END DESC,
  CASE WHEN :sort = 'videos' AND :order = 'asc'
    THEN (SELECT count(*) FROM videos v WHERE v.s_uid = s.uid) END ASC,
  CASE WHEN :sort = 'videos' AND :order = 'desc'
    THEN (SELECT count(*) FROM videos v WHERE v.s_uid = s.uid) END DESC,
  s.name
LIMIT  CAST(COALESCE(NULLIF(:limit,  ''), 60) AS INTEGER)
OFFSET CAST(COALESCE(NULLIF(:offset, ''), 0)  AS INTEGER)

Query parameters

q

sort

order

limit

offset