This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 188 | 188 | f431c | 2245 2245 |
| 15773 | 15773 | f431c | 3316 3316 |
| 16543 | 16543 | f431c | 3372 3372 |
| 17464 | 17464 | f431c | 3356 3356 |
| 23793 | 23793 | f431c | 3032 3032 |
| 28919 | 28919 | f431c | 3073 3073 |
| 29460 | 29460 | f431c | 2859 2859 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)