home / media

media: get_category

Custom SQL query (hide)

SELECT c.uid, c.name, c.nameJa,
       (SELECT count(*) FROM video_category vc WHERE vc.c_uid = c.uid) AS videoCount
FROM categories c WHERE c.uid = :uid

Query parameters

0 results

Powered by Datasette · Queries took 0.247ms