This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
433 | 433 | 9f5e5 | 2381 2381 |
434 | 434 | a7bc0 | 2381 2381 |
435 | 435 | 81536 | 2381 2381 |
436 | 436 | f7339 | 2381 2381 |
437 | 437 | 3bf90 | 2381 2381 |
438 | 438 | 371f0 | 2381 2381 |
439 | 439 | e6200 | 2381 2381 |
440 | 440 | b1201 | 2381 2381 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )