This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5692 | 5692 | ec3ac | 2847 2847 |
| 5693 | 5693 | 3da9b | 2847 2847 |
| 5694 | 5694 | 371f0 | 2847 2847 |
| 5695 | 5695 | e6200 | 2847 2847 |
| 5696 | 5696 | b1201 | 2847 2847 |
| 5697 | 5697 | 902e5 | 2847 2847 |
| 5698 | 5698 | a1307 | 2847 2847 |
| 5699 | 5699 | abb72 | 2847 2847 |
| 5700 | 5700 | 5a04b | 2847 2847 |
| 5701 | 5701 | 27369 | 2847 2847 |
| 5702 | 5702 | 943de | 2847 2847 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)