This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11559 | 11559 | b08d4 | 192 192 |
| 12041 | 12041 | b08d4 | 187 187 |
| 12205 | 12205 | b08d4 | 190 190 |
| 12272 | 12272 | b08d4 | 181 181 |
| 12287 | 12287 | b08d4 | 1951 1951 |
| 12300 | 12300 | b08d4 | 189 189 |
| 31598 | 31598 | b08d4 | 476 476 |
| 31724 | 31724 | b08d4 | 298 298 |
| 31977 | 31977 | b08d4 | 102 102 |
| 32038 | 32038 | b08d4 | 477 477 |
| 32124 | 32124 | b08d4 | 465 465 |
| 32143 | 32143 | b08d4 | 103 103 |
| 32524 | 32524 | b08d4 | 526 526 |
| 33050 | 33050 | b08d4 | 466 466 |
| 35381 | 35381 | b08d4 | 524 524 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)