This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15765 | 15765 | 6b1c5 | 3316 3316 |
| 15766 | 15766 | 7b150 | 3316 3316 |
| 15767 | 15767 | e6200 | 3316 3316 |
| 15768 | 15768 | 3502d | 3316 3316 |
| 15769 | 15769 | b1201 | 3316 3316 |
| 15770 | 15770 | d3559 | 3316 3316 |
| 15771 | 15771 | df1f0 | 3316 3316 |
| 15772 | 15772 | 1d2ab | 3316 3316 |
| 15773 | 15773 | f431c | 3316 3316 |
| 15774 | 15774 | e4356 | 3316 3316 |
| 15775 | 15775 | 27369 | 3316 3316 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)