home / media

media: get_actress

Custom SQL query (hide)

SELECT
  a.uid,
  a.name,
  a.nameJa,
  a.image,
  json(a.alias) AS alias,
  (SELECT count(*) FROM video_star vs WHERE vs.a_uid = a.uid) AS videoCount
FROM actresses a
WHERE a.uid = :uid

Query parameters

0 results

Powered by Datasette · Queries took 0.275ms