This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34745 | 34745 | ec3ac | 1840 1840 |
| 34746 | 34746 | 371f0 | 1840 1840 |
| 34747 | 34747 | 59d75 | 1840 1840 |
| 34748 | 34748 | 3502d | 1840 1840 |
| 34749 | 34749 | 21e56 | 1840 1840 |
| 34750 | 34750 | ac298 | 1840 1840 |
| 34751 | 34751 | 10832 | 1840 1840 |
| 34752 | 34752 | b07dd | 1840 1840 |
| 34753 | 34753 | 0d501 | 1840 1840 |
| 34754 | 34754 | 1bc6c | 1840 1840 |
| 34755 | 34755 | 631df | 1840 1840 |
| 34756 | 34756 | 83345 | 1840 1840 |
| 34757 | 34757 | 8751c | 1840 1840 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)