This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6315 | 6315 | ec3ac | 844 844 |
| 6316 | 6316 | d6ade | 844 844 |
| 6317 | 6317 | 8e7b3 | 844 844 |
| 6318 | 6318 | 313af | 844 844 |
| 6319 | 6319 | ebe26 | 844 844 |
| 6320 | 6320 | a0f55 | 844 844 |
| 6321 | 6321 | 61c1a | 844 844 |
| 6322 | 6322 | 4accc | 844 844 |
| 6323 | 6323 | b1201 | 844 844 |
| 6324 | 6324 | d003e | 844 844 |
| 6325 | 6325 | a340a | 844 844 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)