This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28697 | 28697 | ec3ac | 3274 3274 |
| 28698 | 28698 | 13c3e | 3274 3274 |
| 28699 | 28699 | 371f0 | 3274 3274 |
| 28700 | 28700 | 5e075 | 3274 3274 |
| 28701 | 28701 | 59d75 | 3274 3274 |
| 28702 | 28702 | e6200 | 3274 3274 |
| 28703 | 28703 | b1201 | 3274 3274 |
| 28704 | 28704 | 902e5 | 3274 3274 |
| 28705 | 28705 | 77d7e | 3274 3274 |
| 28706 | 28706 | e5437 | 3274 3274 |
| 28707 | 28707 | 1fd76 | 3274 3274 |
| 28708 | 28708 | 5a70c | 3274 3274 |
| 28709 | 28709 | b3fcc | 3274 3274 |
| 28710 | 28710 | 63250 | 3274 3274 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)