This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13875 | 13875 | ec3ac | 1931 1931 |
| 13876 | 13876 | f5427 | 1931 1931 |
| 13877 | 13877 | 59d75 | 1931 1931 |
| 13878 | 13878 | 3502d | 1931 1931 |
| 13879 | 13879 | a0a68 | 1931 1931 |
| 13880 | 13880 | ca677 | 1931 1931 |
| 13881 | 13881 | 441d6 | 1931 1931 |
| 13882 | 13882 | 0f025 | 1931 1931 |
| 13883 | 13883 | 1de99 | 1931 1931 |
| 13884 | 13884 | 8166c | 1931 1931 |
| 13885 | 13885 | 8bc92 | 1931 1931 |
| 13886 | 13886 | 3edb9 | 1931 1931 |
| 13887 | 13887 | 24608 | 1931 1931 |
| 13888 | 13888 | ff445 | 1931 1931 |
| 13889 | 13889 | a053e | 1931 1931 |
| 13890 | 13890 | 7950f | 1931 1931 |
| 13891 | 13891 | 82e15 | 1931 1931 |
| 13892 | 13892 | d3539 | 1931 1931 |
| 13893 | 13893 | 98a04 | 1931 1931 |
| 13894 | 13894 | ec0bb | 1931 1931 |
| 13895 | 13895 | d68f2 | 1931 1931 |
| 13896 | 13896 | 4a664 | 1931 1931 |
| 13897 | 13897 | 52578 | 1931 1931 |
| 13898 | 13898 | 6492e | 1931 1931 |
| 13899 | 13899 | 82178 | 1931 1931 |
| 13900 | 13900 | a53c4 | 1931 1931 |
| 13901 | 13901 | 13c31 | 1931 1931 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)