This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25085 | 25085 | cc5ed | 3247 3247 |
| 25086 | 25086 | 371f0 | 3247 3247 |
| 25087 | 25087 | e6200 | 3247 3247 |
| 25088 | 25088 | b1201 | 3247 3247 |
| 25089 | 25089 | d9d8c | 3247 3247 |
| 25090 | 25090 | 154c2 | 3247 3247 |
| 25091 | 25091 | 5849a | 3247 3247 |
| 25092 | 25092 | eab5e | 3247 3247 |
| 25093 | 25093 | 5dcb2 | 3247 3247 |
| 25094 | 25094 | d3539 | 3247 3247 |
| 25095 | 25095 | bb97d | 3247 3247 |
| 25096 | 25096 | 4a957 | 3247 3247 |
| 25097 | 25097 | ffca2 | 3247 3247 |
| 25098 | 25098 | 4f89e | 3247 3247 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)