This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36084 | 36084 | cc5ed | 3514 3514 |
| 36085 | 36085 | fa635 | 3514 3514 |
| 36086 | 36086 | e6200 | 3514 3514 |
| 36087 | 36087 | b1201 | 3514 3514 |
| 36088 | 36088 | a48a7 | 3514 3514 |
| 36089 | 36089 | dfca7 | 3514 3514 |
| 36090 | 36090 | c30e5 | 3514 3514 |
| 36091 | 36091 | 33643 | 3514 3514 |
| 36092 | 36092 | a65c5 | 3514 3514 |
| 36093 | 36093 | e456e | 3514 3514 |
| 36094 | 36094 | aff2c | 3514 3514 |
| 36095 | 36095 | bbd8e | 3514 3514 |
| 36096 | 36096 | 8bae1 | 3514 3514 |
| 36097 | 36097 | 4bc77 | 3514 3514 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)