This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27061 | 27061 | ec3ac | 958 958 |
| 27062 | 27062 | 4801f | 958 958 |
| 27063 | 27063 | 5e075 | 958 958 |
| 27064 | 27064 | 59d75 | 958 958 |
| 27065 | 27065 | e6200 | 958 958 |
| 27066 | 27066 | b1201 | 958 958 |
| 27067 | 27067 | d6347 | 958 958 |
| 27068 | 27068 | ebf60 | 958 958 |
| 27069 | 27069 | 9a8c6 | 958 958 |
| 27070 | 27070 | 91693 | 958 958 |
| 27071 | 27071 | 1d2ab | 958 958 |
| 27072 | 27072 | abb72 | 958 958 |
| 27073 | 27073 | 41b26 | 958 958 |
| 27074 | 27074 | 2db78 | 958 958 |
| 27075 | 27075 | 6a38c | 958 958 |
| 27076 | 27076 | e128e | 958 958 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)