This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1440 | 1440 | cc5ed | 2988 2988 |
| 1441 | 1441 | 313af | 2988 2988 |
| 1442 | 1442 | 2cd39 | 2988 2988 |
| 1443 | 1443 | 7ceb1 | 2988 2988 |
| 1444 | 1444 | 371f0 | 2988 2988 |
| 1445 | 1445 | e6200 | 2988 2988 |
| 1446 | 1446 | b1201 | 2988 2988 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)