This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13673 | 13673 | ec3ac | 1940 1940 |
13674 | 13674 | 014b0 | 1940 1940 |
13675 | 13675 | 59d75 | 1940 1940 |
13676 | 13676 | 3502d | 1940 1940 |
13677 | 13677 | d6347 | 1940 1940 |
13678 | 13678 | 18a64 | 1940 1940 |
13679 | 13679 | 7c38f | 1940 1940 |
13680 | 13680 | 27369 | 1940 1940 |
13681 | 13681 | 6a05f | 1940 1940 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )