This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
22781 | 22781 | cc5ed | 2832 2832 |
22782 | 22782 | 3da9b | 2832 2832 |
22783 | 22783 | 371f0 | 2832 2832 |
22784 | 22784 | 5e075 | 2832 2832 |
22785 | 22785 | 59d75 | 2832 2832 |
22786 | 22786 | e6200 | 2832 2832 |
22787 | 22787 | b1201 | 2832 2832 |
22788 | 22788 | 8a7ee | 2832 2832 |
22789 | 22789 | 862ed | 2832 2832 |
22790 | 22790 | f788a | 2832 2832 |
22791 | 22791 | 9848a | 2832 2832 |
22792 | 22792 | abb72 | 2832 2832 |
22793 | 22793 | 27369 | 2832 2832 |
22794 | 22794 | e128e | 2832 2832 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )