video_star
6 rows where v_uid = "v_uyg7h"
This data as json, CSV (advanced)
| Link | v_uid | a_uid |
|---|---|---|
| v_uyg7h,a_32opm | v_uyg7h | Saeki Hanae a_32opm |
| v_uyg7h,a_8hmjp | v_uyg7h | Tomizawa Misuzu a_8hmjp |
| v_uyg7h,a_97it7 | v_uyg7h | Hikari Kuretsuki a_97it7 |
| v_uyg7h,a_aw39g | v_uyg7h | Ishii Michiko a_aw39g |
| v_uyg7h,a_hfvj8 | v_uyg7h | Yamabuki Kayo a_hfvj8 |
| v_uyg7h,a_t0seq | v_uyg7h | Karasuma Madoka a_t0seq |
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);