This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9316 | 9316 | ec3ac | 1401 1401 |
| 9317 | 9317 | 2951c | 1401 1401 |
| 9318 | 9318 | 680d4 | 1401 1401 |
| 9319 | 9319 | a4952 | 1401 1401 |
| 9320 | 9320 | 46ae3 | 1401 1401 |
| 9321 | 9321 | 1d015 | 1401 1401 |
| 9322 | 9322 | 12e44 | 1401 1401 |
| 9323 | 9323 | 371f0 | 1401 1401 |
| 9324 | 9324 | 5e075 | 1401 1401 |
| 9325 | 9325 | 59d75 | 1401 1401 |
| 9326 | 9326 | e6200 | 1401 1401 |
| 9327 | 9327 | b1201 | 1401 1401 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)