This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3074 | 3074 | 1ef30 | 323 323 |
| 3075 | 3075 | c448c | 323 323 |
| 3076 | 3076 | a1ac8 | 323 323 |
| 3077 | 3077 | 18d8d | 323 323 |
| 3078 | 3078 | 6fba5 | 323 323 |
| 3079 | 3079 | 371f0 | 323 323 |
| 3080 | 3080 | 5e075 | 323 323 |
| 3081 | 3081 | 59d75 | 323 323 |
| 3082 | 3082 | e6200 | 323 323 |
| 3083 | 3083 | b1201 | 323 323 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)