This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25231 | 25231 | cc5ed | 2923 2923 |
| 25232 | 25232 | cb80d | 2923 2923 |
| 25233 | 25233 | 371f0 | 2923 2923 |
| 25234 | 25234 | bf1e7 | 2923 2923 |
| 25235 | 25235 | e6200 | 2923 2923 |
| 25236 | 25236 | b1201 | 2923 2923 |
| 25237 | 25237 | 902e5 | 2923 2923 |
| 25238 | 25238 | bc1ac | 2923 2923 |
| 25239 | 25239 | 22955 | 2923 2923 |
| 25240 | 25240 | 6ec75 | 2923 2923 |
| 25241 | 25241 | 77d7e | 2923 2923 |
| 25242 | 25242 | c46d7 | 2923 2923 |
| 25243 | 25243 | feaa7 | 2923 2923 |
| 25244 | 25244 | 07bb3 | 2923 2923 |
| 25245 | 25245 | a7f5a | 2923 2923 |
| 25246 | 25246 | 4a7fd | 2923 2923 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)