This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6725 | 6725 | a26ae | 1611 1611 |
| 6726 | 6726 | e541b | 1611 1611 |
| 6727 | 6727 | ec3ac | 1611 1611 |
| 6728 | 6728 | 4de4f | 1611 1611 |
| 6729 | 6729 | 371f0 | 1611 1611 |
| 6730 | 6730 | e6200 | 1611 1611 |
| 6731 | 6731 | b1201 | 1611 1611 |
| 6732 | 6732 | 902e5 | 1611 1611 |
| 6733 | 6733 | b4119 | 1611 1611 |
| 6734 | 6734 | 5185c | 1611 1611 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)