This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
23693 | 23693 | cc5ed | 2915 2915 |
23694 | 23694 | c1190 | 2915 2915 |
23695 | 23695 | cb80d | 2915 2915 |
23696 | 23696 | 371f0 | 2915 2915 |
23697 | 23697 | bf1e7 | 2915 2915 |
23698 | 23698 | e6200 | 2915 2915 |
23699 | 23699 | b1201 | 2915 2915 |
23700 | 23700 | 902e5 | 2915 2915 |
23701 | 23701 | bc1ac | 2915 2915 |
23702 | 23702 | 6ec75 | 2915 2915 |
23703 | 23703 | 5b456 | 2915 2915 |
23704 | 23704 | 77d7e | 2915 2915 |
23705 | 23705 | 469ba | 2915 2915 |
23706 | 23706 | b4bbb | 2915 2915 |
23707 | 23707 | 1aa29 | 2915 2915 |
23708 | 23708 | b0c29 | 2915 2915 |
23709 | 23709 | 87529 | 2915 2915 |
23710 | 23710 | 1d7a4 | 2915 2915 |
23711 | 23711 | 266f1 | 2915 2915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )