This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30136 | 30136 | 3bf00 | 3281 3281 |
| 30137 | 30137 | 75744 | 3281 3281 |
| 30138 | 30138 | 371f0 | 3281 3281 |
| 30139 | 30139 | 5e075 | 3281 3281 |
| 30140 | 30140 | 59d75 | 3281 3281 |
| 30141 | 30141 | e6200 | 3281 3281 |
| 30142 | 30142 | b1201 | 3281 3281 |
| 30143 | 30143 | 902e5 | 3281 3281 |
| 30144 | 30144 | f0b0e | 3281 3281 |
| 30145 | 30145 | bd053 | 3281 3281 |
| 30146 | 30146 | 7f52f | 3281 3281 |
| 30147 | 30147 | bb729 | 3281 3281 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)