This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16427 | 16427 | ec3ac | 3312 3312 |
| 16428 | 16428 | bcd9a | 3312 3312 |
| 16429 | 16429 | 371f0 | 3312 3312 |
| 16430 | 16430 | 5e075 | 3312 3312 |
| 16431 | 16431 | 59d75 | 3312 3312 |
| 16432 | 16432 | e6200 | 3312 3312 |
| 16433 | 16433 | b1201 | 3312 3312 |
| 16434 | 16434 | 902e5 | 3312 3312 |
| 16435 | 16435 | 30b5d | 3312 3312 |
| 16436 | 16436 | 2d992 | 3312 3312 |
| 16437 | 16437 | 2e75d | 3312 3312 |
| 16438 | 16438 | adf9e | 3312 3312 |
| 16439 | 16439 | 7044b | 3312 3312 |
| 16440 | 16440 | e20e8 | 3312 3312 |
| 16441 | 16441 | e8c22 | 3312 3312 |
| 16442 | 16442 | a263e | 3312 3312 |
| 16443 | 16443 | bf304 | 3312 3312 |
| 16444 | 16444 | d0c02 | 3312 3312 |
| 16445 | 16445 | c6866 | 3312 3312 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)