media: get_label

Custom SQL query (hide)

SELECT l.uid, l.name, l.nameJa,
       (SELECT count(*) FROM video_label vl WHERE vl.l_uid = l.uid) AS videoCount
FROM labels l WHERE l.uid = :uid

Query parameters

uid