This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16070 | 16070 | cc5ed | 3382 3382 |
| 16071 | 16071 | 8f048 | 3382 3382 |
| 16072 | 16072 | 59d75 | 3382 3382 |
| 16073 | 16073 | e6200 | 3382 3382 |
| 16074 | 16074 | b1201 | 3382 3382 |
| 16075 | 16075 | 902e5 | 3382 3382 |
| 16076 | 16076 | 7dde7 | 3382 3382 |
| 16077 | 16077 | 4f99d | 3382 3382 |
| 16078 | 16078 | d793b | 3382 3382 |
| 16079 | 16079 | 1711f | 3382 3382 |
| 16080 | 16080 | 68f7c | 3382 3382 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)