This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6735 | 6735 | ec3ac | 1104 1104 |
| 6736 | 6736 | bca17 | 1104 1104 |
| 6737 | 6737 | 2dfbd | 1104 1104 |
| 6738 | 6738 | 4e7f1 | 1104 1104 |
| 6739 | 6739 | 1073c | 1104 1104 |
| 6740 | 6740 | 4801f | 1104 1104 |
| 6741 | 6741 | 5e075 | 1104 1104 |
| 6742 | 6742 | 59d75 | 1104 1104 |
| 6743 | 6743 | e6200 | 1104 1104 |
| 6744 | 6744 | b1201 | 1104 1104 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)