This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10347 | 10347 | ec3ac | 1794 1794 |
10348 | 10348 | 398aa | 1794 1794 |
10349 | 10349 | 18789 | 1794 1794 |
10350 | 10350 | 49bfd | 1794 1794 |
10351 | 10351 | 371f0 | 1794 1794 |
10352 | 10352 | e6200 | 1794 1794 |
10353 | 10353 | b1201 | 1794 1794 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )