This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16081 | 16081 | ec3ac | 3388 3388 |
| 16082 | 16082 | e5946 | 3388 3388 |
| 16083 | 16083 | 95ebf | 3388 3388 |
| 16084 | 16084 | 59d75 | 3388 3388 |
| 16085 | 16085 | e6200 | 3388 3388 |
| 16086 | 16086 | 3502d | 3388 3388 |
| 16087 | 16087 | b1201 | 3388 3388 |
| 16088 | 16088 | b85e0 | 3388 3388 |
| 16089 | 16089 | a0884 | 3388 3388 |
| 16090 | 16090 | 2300e | 3388 3388 |
| 16091 | 16091 | 73272 | 3388 3388 |
| 16092 | 16092 | 6f82c | 3388 3388 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)