This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22072 | 22072 | ec3ac | 997 997 |
| 22073 | 22073 | 4801f | 997 997 |
| 22074 | 22074 | 5e075 | 997 997 |
| 22075 | 22075 | 59d75 | 997 997 |
| 22076 | 22076 | e6200 | 997 997 |
| 22077 | 22077 | b1201 | 997 997 |
| 22078 | 22078 | d6347 | 997 997 |
| 22079 | 22079 | ebf60 | 997 997 |
| 22080 | 22080 | 9a8c6 | 997 997 |
| 22081 | 22081 | 91693 | 997 997 |
| 22082 | 22082 | 1d2ab | 997 997 |
| 22083 | 22083 | abb72 | 997 997 |
| 22084 | 22084 | 41b26 | 997 997 |
| 22085 | 22085 | 2db78 | 997 997 |
| 22086 | 22086 | 6a38c | 997 997 |
| 22087 | 22087 | e128e | 997 997 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)