home / media

media: get_director

Custom SQL query (hide)

SELECT d.uid, d.name, d.nameJa,
       (SELECT count(*) FROM video_director vd WHERE vd.d_uid = d.uid) AS videoCount
FROM directors d WHERE d.uid = :uid

Query parameters

0 results

Powered by Datasette · Queries took 0.384ms