This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16038 | 16038 | ec3ac | 3386 3386 |
| 16039 | 16039 | e5946 | 3386 3386 |
| 16040 | 16040 | 95ebf | 3386 3386 |
| 16041 | 16041 | 59d75 | 3386 3386 |
| 16042 | 16042 | e6200 | 3386 3386 |
| 16043 | 16043 | 3502d | 3386 3386 |
| 16044 | 16044 | b1201 | 3386 3386 |
| 16045 | 16045 | b85e0 | 3386 3386 |
| 16046 | 16046 | a0884 | 3386 3386 |
| 16047 | 16047 | 2300e | 3386 3386 |
| 16048 | 16048 | 73272 | 3386 3386 |
| 16049 | 16049 | 6f82c | 3386 3386 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)