This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2415 | 2415 | ec3ac | 1584 1584 |
2416 | 2416 | 6d4d3 | 1584 1584 |
2417 | 2417 | 7ceb1 | 1584 1584 |
2418 | 2418 | 6b827 | 1584 1584 |
2419 | 2419 | 371f0 | 1584 1584 |
2420 | 2420 | 5e075 | 1584 1584 |
2421 | 2421 | 59d75 | 1584 1584 |
2422 | 2422 | e6200 | 1584 1584 |
2423 | 2423 | b1201 | 1584 1584 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )