This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6049 | 6049 | f6566 | 691 691 |
7602 | 7602 | f6566 | 686 686 |
15442 | 15442 | f6566 | 1885 1885 |
31545 | 31545 | f6566 | 2444 2444 |
31842 | 31842 | f6566 | 2440 2440 |
32166 | 32166 | f6566 | 2443 2443 |
32447 | 32447 | f6566 | 2439 2439 |
32636 | 32636 | f6566 | 2441 2441 |
32980 | 32980 | f6566 | 2442 2442 |
34607 | 34607 | f6566 | 1910 1910 |
35290 | 35290 | f6566 | 32 32 |
35407 | 35407 | f6566 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )