This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5492 | 5492 | ec3ac | 1064 1064 |
| 5493 | 5493 | 16102 | 1064 1064 |
| 5494 | 5494 | e9db4 | 1064 1064 |
| 5495 | 5495 | 1f895 | 1064 1064 |
| 5496 | 5496 | a5df2 | 1064 1064 |
| 5497 | 5497 | c3780 | 1064 1064 |
| 5498 | 5498 | d582c | 1064 1064 |
| 5499 | 5499 | 8de7c | 1064 1064 |
| 5500 | 5500 | cbcce | 1064 1064 |
| 5501 | 5501 | 1073c | 1064 1064 |
| 5502 | 5502 | 4801f | 1064 1064 |
| 5503 | 5503 | 5e075 | 1064 1064 |
| 5504 | 5504 | 59d75 | 1064 1064 |
| 5505 | 5505 | e6200 | 1064 1064 |
| 5506 | 5506 | b1201 | 1064 1064 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)