This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26434 | 26434 | ec3ac | 1020 1020 |
| 26435 | 26435 | 4801f | 1020 1020 |
| 26436 | 26436 | 5e075 | 1020 1020 |
| 26437 | 26437 | 59d75 | 1020 1020 |
| 26438 | 26438 | e6200 | 1020 1020 |
| 26439 | 26439 | b1201 | 1020 1020 |
| 26440 | 26440 | d6347 | 1020 1020 |
| 26441 | 26441 | ebf60 | 1020 1020 |
| 26442 | 26442 | 9a8c6 | 1020 1020 |
| 26443 | 26443 | 91693 | 1020 1020 |
| 26444 | 26444 | 1d2ab | 1020 1020 |
| 26445 | 26445 | abb72 | 1020 1020 |
| 26446 | 26446 | 41b26 | 1020 1020 |
| 26447 | 26447 | 2db78 | 1020 1020 |
| 26448 | 26448 | 6a38c | 1020 1020 |
| 26449 | 26449 | e128e | 1020 1020 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)