This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25890 | 25890 | cc5ed | 2734 2734 |
| 25891 | 25891 | 371f0 | 2734 2734 |
| 25892 | 25892 | e6200 | 2734 2734 |
| 25893 | 25893 | b1201 | 2734 2734 |
| 25894 | 25894 | d9d8c | 2734 2734 |
| 25895 | 25895 | 5f10e | 2734 2734 |
| 25896 | 25896 | 5849a | 2734 2734 |
| 25897 | 25897 | eab5e | 2734 2734 |
| 25898 | 25898 | 8b401 | 2734 2734 |
| 25899 | 25899 | 007df | 2734 2734 |
| 25900 | 25900 | 5dcb2 | 2734 2734 |
| 25901 | 25901 | d3539 | 2734 2734 |
| 25902 | 25902 | 60626 | 2734 2734 |
| 25903 | 25903 | 4a957 | 2734 2734 |
| 25904 | 25904 | 839f9 | 2734 2734 |
| 25905 | 25905 | ffca2 | 2734 2734 |
| 25906 | 25906 | 4f89e | 2734 2734 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)