video_star
9 rows where v_uid = "v_mtnry"
This data as json, CSV (advanced)
| Link | v_uid | a_uid |
|---|---|---|
| v_mtnry,a_0awbr | v_mtnry | Seino Fumie a_0awbr |
| v_mtnry,a_0fsr9 | v_mtnry | Omiya Ryoka a_0fsr9 |
| v_mtnry,a_0zdow | v_mtnry | Nagaoka Masami a_0zdow |
| v_mtnry,a_63jkq | v_mtnry | Niikura Masami a_63jkq |
| v_mtnry,a_64wgn | v_mtnry | Suou Aki a_64wgn |
| v_mtnry,a_b8xa5 | v_mtnry | Tokigoshi Fumie a_b8xa5 |
| v_mtnry,a_i3sq2 | v_mtnry | Mihara Sakiko a_i3sq2 |
| v_mtnry,a_mynzq | v_mtnry | Hattori Keiko a_mynzq |
| v_mtnry,a_o4ff6 | v_mtnry | Shoda Chisato a_o4ff6 |
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);