media: get_top_actresses

Custom SQL query (hide) 

SELECT
  t.rank,
  a.uid, a.name, a.nameJa, a.image,
  (SELECT count(*) FROM video_star vs WHERE vs.a_uid = a.uid) AS videoCount
FROM actresses_top t
JOIN actresses a ON a.uid = t.a_uid
ORDER BY t.rank
LIMIT CAST(COALESCE(NULLIF(:limit, ''), 100) AS INTEGER)

Query parameters

0 results