This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16546 | 16546 | cc5ed | 3018 3018 |
16547 | 16547 | 371f0 | 3018 3018 |
16548 | 16548 | e6200 | 3018 3018 |
16549 | 16549 | b1201 | 3018 3018 |
16550 | 16550 | 8a7ee | 3018 3018 |
16551 | 16551 | 862ed | 3018 3018 |
16552 | 16552 | 487f2 | 3018 3018 |
16553 | 16553 | 3fbed | 3018 3018 |
16554 | 16554 | 27369 | 3018 3018 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )