This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5667 | 5667 | ec3ac | 3002 3002 |
| 5668 | 5668 | 6060b | 3002 3002 |
| 5669 | 5669 | 371f0 | 3002 3002 |
| 5670 | 5670 | 59d75 | 3002 3002 |
| 5671 | 5671 | e6200 | 3002 3002 |
| 5672 | 5672 | b1201 | 3002 3002 |
| 5673 | 5673 | 902e5 | 3002 3002 |
| 5674 | 5674 | 8a7ee | 3002 3002 |
| 5675 | 5675 | 862ed | 3002 3002 |
| 5676 | 5676 | 4d5c2 | 3002 3002 |
| 5677 | 5677 | 6a9d7 | 3002 3002 |
| 5678 | 5678 | 225c8 | 3002 3002 |
| 5679 | 5679 | 466b8 | 3002 3002 |
| 5680 | 5680 | e4b8e | 3002 3002 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)