This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16859 | 16859 | cc5ed | 3118 3118 |
| 16860 | 16860 | d6ade | 3118 3118 |
| 16861 | 16861 | 8e7b3 | 3118 3118 |
| 16862 | 16862 | 2dfbd | 3118 3118 |
| 16863 | 16863 | 4e7f1 | 3118 3118 |
| 16864 | 16864 | a0f55 | 3118 3118 |
| 16865 | 16865 | 371f0 | 3118 3118 |
| 16866 | 16866 | e6200 | 3118 3118 |
| 16867 | 16867 | b1201 | 3118 3118 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)