This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33184 | 33184 | ec3ac | 1832 1832 |
| 33185 | 33185 | 0771c | 1832 1832 |
| 33186 | 33186 | cf58f | 1832 1832 |
| 33187 | 33187 | c3e59 | 1832 1832 |
| 33188 | 33188 | 46069 | 1832 1832 |
| 33189 | 33189 | 5e998 | 1832 1832 |
| 33190 | 33190 | 00d26 | 1832 1832 |
| 33191 | 33191 | e6200 | 1832 1832 |
| 33192 | 33192 | b1201 | 1832 1832 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)