This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34879 | 34879 | a26ae | 89 89 |
34880 | 34880 | 6e224 | 89 89 |
34881 | 34881 | c6e92 | 89 89 |
34882 | 34882 | 371f0 | 89 89 |
34883 | 34883 | 5e075 | 89 89 |
34884 | 34884 | 59d75 | 89 89 |
34885 | 34885 | e6200 | 89 89 |
34886 | 34886 | b1201 | 89 89 |
34887 | 34887 | b9d0a | 89 89 |
34888 | 34888 | 27369 | 89 89 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )