This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15386 | 15386 | ec3ac | 7 7 |
| 15387 | 15387 | fbe53 | 7 7 |
| 15388 | 15388 | 59d75 | 7 7 |
| 15389 | 15389 | 3502d | 7 7 |
| 15390 | 15390 | a755b | 7 7 |
| 15391 | 15391 | 87070 | 7 7 |
| 15392 | 15392 | 86f51 | 7 7 |
| 15393 | 15393 | 0c5c0 | 7 7 |
| 15394 | 15394 | a44f5 | 7 7 |
| 15395 | 15395 | 88b57 | 7 7 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)