This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 4484 | 4484 | dd761 | 372 372 |
| 4485 | 4485 | a1ac8 | 372 372 |
| 4486 | 4486 | 6fba5 | 372 372 |
| 4487 | 4487 | 371f0 | 372 372 |
| 4488 | 4488 | 5e075 | 372 372 |
| 4489 | 4489 | 59d75 | 372 372 |
| 4490 | 4490 | e6200 | 372 372 |
| 4491 | 4491 | b1201 | 372 372 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)