This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26030 | 26030 | ec3ac | 2764 2764 |
| 26031 | 26031 | 3909d | 2764 2764 |
| 26032 | 26032 | 371f0 | 2764 2764 |
| 26033 | 26033 | 5e075 | 2764 2764 |
| 26034 | 26034 | 59d75 | 2764 2764 |
| 26035 | 26035 | e6200 | 2764 2764 |
| 26036 | 26036 | b1201 | 2764 2764 |
| 26037 | 26037 | d745f | 2764 2764 |
| 26038 | 26038 | 27704 | 2764 2764 |
| 26039 | 26039 | ae91e | 2764 2764 |
| 26040 | 26040 | 0eea2 | 2764 2764 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)