This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22228 | 22228 | cc5ed | 2954 2954 |
| 22229 | 22229 | c1190 | 2954 2954 |
| 22230 | 22230 | cb80d | 2954 2954 |
| 22231 | 22231 | 371f0 | 2954 2954 |
| 22232 | 22232 | bf1e7 | 2954 2954 |
| 22233 | 22233 | e6200 | 2954 2954 |
| 22234 | 22234 | b1201 | 2954 2954 |
| 22235 | 22235 | 902e5 | 2954 2954 |
| 22236 | 22236 | bc1ac | 2954 2954 |
| 22237 | 22237 | 6ec75 | 2954 2954 |
| 22238 | 22238 | 5b456 | 2954 2954 |
| 22239 | 22239 | 77d7e | 2954 2954 |
| 22240 | 22240 | 88f4a | 2954 2954 |
| 22241 | 22241 | ed59f | 2954 2954 |
| 22242 | 22242 | b4bbb | 2954 2954 |
| 22243 | 22243 | 1aa29 | 2954 2954 |
| 22244 | 22244 | 51ad1 | 2954 2954 |
| 22245 | 22245 | b0c29 | 2954 2954 |
| 22246 | 22246 | 87529 | 2954 2954 |
| 22247 | 22247 | 1d7a4 | 2954 2954 |
| 22248 | 22248 | 266f1 | 2954 2954 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)