This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11362 | 11362 | ec3ac | 1701 1701 |
11363 | 11363 | d1e7b | 1701 1701 |
11364 | 11364 | 3502d | 1701 1701 |
11365 | 11365 | 9fe47 | 1701 1701 |
11366 | 11366 | 30a44 | 1701 1701 |
11367 | 11367 | e1f0e | 1701 1701 |
11368 | 11368 | 9a8c6 | 1701 1701 |
11369 | 11369 | e4519 | 1701 1701 |
11370 | 11370 | 0deb1 | 1701 1701 |
11371 | 11371 | 6a38c | 1701 1701 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )