This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29276 | 29276 | ec3ac | 3083 3083 |
| 29277 | 29277 | b668a | 3083 3083 |
| 29278 | 29278 | 371f0 | 3083 3083 |
| 29279 | 29279 | 5e075 | 3083 3083 |
| 29280 | 29280 | 59d75 | 3083 3083 |
| 29281 | 29281 | e6200 | 3083 3083 |
| 29282 | 29282 | b1201 | 3083 3083 |
| 29283 | 29283 | 902e5 | 3083 3083 |
| 29284 | 29284 | e128e | 3083 3083 |
| 29285 | 29285 | 598d9 | 3083 3083 |
| 29286 | 29286 | 04629 | 3083 3083 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)