This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31568 | 31568 | ec3ac | 1636 1636 |
| 31569 | 31569 | b14b0 | 1636 1636 |
| 31570 | 31570 | 1e305 | 1636 1636 |
| 31571 | 31571 | 0733f | 1636 1636 |
| 31572 | 31572 | 1b3de | 1636 1636 |
| 31573 | 31573 | a14cf | 1636 1636 |
| 31574 | 31574 | 5e075 | 1636 1636 |
| 31575 | 31575 | a4abf | 1636 1636 |
| 31576 | 31576 | 59d75 | 1636 1636 |
| 31577 | 31577 | e6200 | 1636 1636 |
| 31578 | 31578 | b1201 | 1636 1636 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)