This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34716 | 34716 | ec3ac | 1684 1684 |
| 34717 | 34717 | 371f0 | 1684 1684 |
| 34718 | 34718 | 59d75 | 1684 1684 |
| 34719 | 34719 | 3502d | 1684 1684 |
| 34720 | 34720 | 18a64 | 1684 1684 |
| 34721 | 34721 | d65e1 | 1684 1684 |
| 34722 | 34722 | f788a | 1684 1684 |
| 34723 | 34723 | d1aa5 | 1684 1684 |
| 34724 | 34724 | 809af | 1684 1684 |
| 34725 | 34725 | abb72 | 1684 1684 |
| 34726 | 34726 | 2ce65 | 1684 1684 |
| 34727 | 34727 | 27369 | 1684 1684 |
| 34728 | 34728 | 7746b | 1684 1684 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)