This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3075 | 3075 | c448c | 323 323 |
| 3085 | 3085 | c448c | 94 94 |
| 3268 | 3268 | c448c | 319 319 |
| 3302 | 3302 | c448c | 324 324 |
| 3322 | 3322 | c448c | 322 322 |
| 3404 | 3404 | c448c | 95 95 |
| 3422 | 3422 | c448c | 320 320 |
| 3461 | 3461 | c448c | 100 100 |
| 3562 | 3562 | c448c | 321 321 |
| 3732 | 3732 | c448c | 101 101 |
| 3758 | 3758 | c448c | 54 54 |
| 3784 | 3784 | c448c | 53 53 |
| 3993 | 3993 | c448c | 111 111 |
| 4046 | 4046 | c448c | 110 110 |
| 12281 | 12281 | c448c | 1951 1951 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)