home / media

video_star

10 rows where v_uid = "v_tdly1"

This data as json, CSV (advanced)

Link v_uid a_uid
v_tdly1,a_7lr2a v_tdly1 Sakamoto Rio a_7lr2a
v_tdly1,a_8729y v_tdly1 Yosii Miki a_8729y
v_tdly1,a_aftns v_tdly1 Yuki Nao a_aftns
v_tdly1,a_bnz8v v_tdly1 ohara Rio a_bnz8v
v_tdly1,a_fg59v v_tdly1 Mihara Sumire a_fg59v
v_tdly1,a_fz8e2 v_tdly1 Shirosaki Kyoka a_fz8e2
v_tdly1,a_hay94 v_tdly1 Azuma Suzu a_hay94
v_tdly1,a_o9b4y v_tdly1 Kawamura Manami a_o9b4y
v_tdly1,a_td4bl v_tdly1 Mio Ichijō a_td4bl
v_tdly1,a_v3vcg v_tdly1 Kawakita Ema a_v3vcg

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE video_star (
  v_uid TEXT NOT NULL REFERENCES videos(uid)    ON DELETE CASCADE,
  a_uid TEXT NOT NULL REFERENCES actresses(uid) ON DELETE CASCADE,
  PRIMARY KEY (v_uid, a_uid)
);
CREATE INDEX idx_video_star_a ON video_star(a_uid);
Powered by Datasette · Queries took 2.62ms