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
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);