This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
751 | 751 | 4e97e | 2392 2392 |
752 | 752 | 371f0 | 2392 2392 |
753 | 753 | e6200 | 2392 2392 |
754 | 754 | b1201 | 2392 2392 |
755 | 755 | 8a7ee | 2392 2392 |
756 | 756 | 862ed | 2392 2392 |
757 | 757 | 487f2 | 2392 2392 |
758 | 758 | abb72 | 2392 2392 |
759 | 759 | 27369 | 2392 2392 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )