This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1227 | 1227 | ec3ac | 1045 1045 |
| 1228 | 1228 | 17183 | 1045 1045 |
| 1229 | 1229 | 96bbd | 1045 1045 |
| 1230 | 1230 | 550f6 | 1045 1045 |
| 1231 | 1231 | 343d8 | 1045 1045 |
| 1232 | 1232 | e0460 | 1045 1045 |
| 1233 | 1233 | 02db8 | 1045 1045 |
| 1234 | 1234 | aabe0 | 1045 1045 |
| 1235 | 1235 | 3e5f6 | 1045 1045 |
| 1236 | 1236 | 87fac | 1045 1045 |
| 1237 | 1237 | 1073c | 1045 1045 |
| 1238 | 1238 | 4801f | 1045 1045 |
| 1239 | 1239 | 5e075 | 1045 1045 |
| 1240 | 1240 | 59d75 | 1045 1045 |
| 1241 | 1241 | e6200 | 1045 1045 |
| 1242 | 1242 | b1201 | 1045 1045 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)