This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6664 | 6664 | 64bc4 | 2808 2808 |
| 6722 | 6722 | 64bc4 | 2810 2810 |
| 7413 | 7413 | 64bc4 | 2809 2809 |
| 15932 | 15932 | 64bc4 | 3198 3198 |
| 17582 | 17582 | 64bc4 | 3216 3216 |
| 18087 | 18087 | 64bc4 | 3215 3215 |
| 29636 | 29636 | 64bc4 | 3213 3213 |
| 30374 | 30374 | 64bc4 | 3209 3209 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)