This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
8986 | 8986 | ec3ac | 1886 1886 |
8987 | 8987 | 88a54 | 1886 1886 |
8988 | 8988 | 40ff5 | 1886 1886 |
8989 | 8989 | f5427 | 1886 1886 |
8990 | 8990 | 59d75 | 1886 1886 |
8991 | 8991 | 3502d | 1886 1886 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )