This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5230 | 5230 | cc5ed | 2867 2867 |
| 5231 | 5231 | 3da9b | 2867 2867 |
| 5232 | 5232 | 371f0 | 2867 2867 |
| 5233 | 5233 | 5e075 | 2867 2867 |
| 5234 | 5234 | 59d75 | 2867 2867 |
| 5235 | 5235 | e6200 | 2867 2867 |
| 5236 | 5236 | b1201 | 2867 2867 |
| 5237 | 5237 | 902e5 | 2867 2867 |
| 5238 | 5238 | 18a64 | 2867 2867 |
| 5239 | 5239 | f788a | 2867 2867 |
| 5240 | 5240 | 7c38f | 2867 2867 |
| 5241 | 5241 | abb72 | 2867 2867 |
| 5242 | 5242 | e128e | 2867 2867 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)