media: get_top_videos

Custom SQL query (hide) 

SELECT
  t.rank,
  v.uid, v.code, v.titleEn, v.titleJa,
  v.jacketFullUrl, v.jacketThumbUrl, v.releaseDate, v.runtimeMins,
  json((
    SELECT json_group_array(
      json_object('uid', a.uid, 'name', a.name, 'image', a.image)
    )
    FROM video_star vs
    JOIN actresses a ON a.uid = vs.a_uid
    WHERE vs.v_uid = v.uid
  )) AS actresses,
  (SELECT count(*) FROM streams s WHERE s.v_uid = v.uid) AS streamCount
FROM videos_top t
JOIN videos v ON v.uid = t.v_uid
WHERE t.period = :period
ORDER BY t.rank
LIMIT CAST(COALESCE(NULLIF(:limit, ''), 100) AS INTEGER)

Query parameters

0 results