This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15898 | 15898 | cc5ed | 2865 2865 |
15899 | 15899 | 3da9b | 2865 2865 |
15900 | 15900 | 371f0 | 2865 2865 |
15901 | 15901 | 5e075 | 2865 2865 |
15902 | 15902 | 59d75 | 2865 2865 |
15903 | 15903 | e6200 | 2865 2865 |
15904 | 15904 | b1201 | 2865 2865 |
15905 | 15905 | 8a7ee | 2865 2865 |
15906 | 15906 | 862ed | 2865 2865 |
15907 | 15907 | f788a | 2865 2865 |
15908 | 15908 | 9848a | 2865 2865 |
15909 | 15909 | 3fbed | 2865 2865 |
15910 | 15910 | 27369 | 2865 2865 |
15911 | 15911 | e128e | 2865 2865 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )