This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34124 | 34124 | ec3ac | 828 828 |
| 34125 | 34125 | b668a | 828 828 |
| 34126 | 34126 | a14cf | 828 828 |
| 34127 | 34127 | 5e075 | 828 828 |
| 34128 | 34128 | 59d75 | 828 828 |
| 34129 | 34129 | e6200 | 828 828 |
| 34130 | 34130 | b1201 | 828 828 |
| 34131 | 34131 | b42a4 | 828 828 |
| 34132 | 34132 | d679e | 828 828 |
| 34133 | 34133 | 17bc7 | 828 828 |
| 34134 | 34134 | aa04d | 828 828 |
| 34135 | 34135 | 95f91 | 828 828 |
| 34136 | 34136 | 65a38 | 828 828 |
| 34137 | 34137 | e128e | 828 828 |
| 34138 | 34138 | d75c0 | 828 828 |
| 34139 | 34139 | 16071 | 828 828 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)