This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33579 | 33579 | e5ea3 | 1296 1296 |
33580 | 33580 | ea4d7 | 1296 1296 |
33581 | 33581 | 371f0 | 1296 1296 |
33582 | 33582 | 5e075 | 1296 1296 |
33583 | 33583 | 59d75 | 1296 1296 |
33584 | 33584 | e6200 | 1296 1296 |
33585 | 33585 | b1201 | 1296 1296 |
33586 | 33586 | edd58 | 1296 1296 |
33587 | 33587 | 8355d | 1296 1296 |
33588 | 33588 | f03e5 | 1296 1296 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )