This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5857 | 5857 | 201fd | 2783 2783 |
9670 | 9670 | 201fd | 515 515 |
10048 | 10048 | 201fd | 532 532 |
10209 | 10209 | 201fd | 487 487 |
10997 | 10997 | 201fd | 486 486 |
13095 | 13095 | 201fd | 34 34 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )