This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5478 | 5478 | f4bd7 | 3176 3176 |
6688 | 6688 | f4bd7 | 2739 2739 |
31600 | 31600 | f4bd7 | 476 476 |
32040 | 32040 | f4bd7 | 477 477 |
32126 | 32126 | f4bd7 | 465 465 |
32526 | 32526 | f4bd7 | 526 526 |
32958 | 32958 | f4bd7 | 479 479 |
33052 | 33052 | f4bd7 | 466 466 |
34583 | 34583 | f4bd7 | 1785 1785 |
34942 | 34942 | f4bd7 | 525 525 |
35113 | 35113 | f4bd7 | 3503 3503 |
35163 | 35163 | f4bd7 | 3504 3504 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )