This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5033 | 5033 | cc5ed | 2755 2755 |
5034 | 5034 | 3fb0e | 2755 2755 |
5035 | 5035 | e6200 | 2755 2755 |
5036 | 5036 | b1201 | 2755 2755 |
5037 | 5037 | db8b3 | 2755 2755 |
5038 | 5038 | 2113e | 2755 2755 |
5039 | 5039 | 1e955 | 2755 2755 |
5040 | 5040 | 22cc9 | 2755 2755 |
5041 | 5041 | 0f722 | 2755 2755 |
5042 | 5042 | 984e7 | 2755 2755 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )