This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20745 | 20745 | cc5ed | 2470 2470 |
| 20746 | 20746 | 82db1 | 2470 2470 |
| 20747 | 20747 | 371f0 | 2470 2470 |
| 20748 | 20748 | 5e075 | 2470 2470 |
| 20749 | 20749 | 59d75 | 2470 2470 |
| 20750 | 20750 | e6200 | 2470 2470 |
| 20751 | 20751 | b1201 | 2470 2470 |
| 20752 | 20752 | 902e5 | 2470 2470 |
| 20753 | 20753 | 7746b | 2470 2470 |
| 20754 | 20754 | eeb2f | 2470 2470 |
| 20755 | 20755 | f9497 | 2470 2470 |
| 20756 | 20756 | 0da89 | 2470 2470 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)