This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12212 | 12212 | e9f7c | 190 190 |
| 12228 | 12228 | e9f7c | 182 182 |
| 33795 | 33795 | e9f7c | 817 817 |
| 33838 | 33838 | e9f7c | 831 831 |
| 33881 | 33881 | e9f7c | 778 778 |
| 33937 | 33937 | e9f7c | 812 812 |
| 34270 | 34270 | e9f7c | 791 791 |
| 34326 | 34326 | e9f7c | 783 783 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)