This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 419 | 419 | ec3ac | 3080 3080 |
| 420 | 420 | b668a | 3080 3080 |
| 421 | 421 | 371f0 | 3080 3080 |
| 422 | 422 | 5e075 | 3080 3080 |
| 423 | 423 | 59d75 | 3080 3080 |
| 424 | 424 | e6200 | 3080 3080 |
| 425 | 425 | b1201 | 3080 3080 |
| 426 | 426 | 902e5 | 3080 3080 |
| 427 | 427 | 8a7ee | 3080 3080 |
| 428 | 428 | 862ed | 3080 3080 |
| 429 | 429 | a1307 | 3080 3080 |
| 430 | 430 | abb72 | 3080 3080 |
| 431 | 431 | 27369 | 3080 3080 |
| 432 | 432 | 04629 | 3080 3080 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)