This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5082 | 5082 | cc5ed | 3015 3015 |
5083 | 5083 | 6060b | 3015 3015 |
5084 | 5084 | 371f0 | 3015 3015 |
5085 | 5085 | 59d75 | 3015 3015 |
5086 | 5086 | e6200 | 3015 3015 |
5087 | 5087 | b1201 | 3015 3015 |
5088 | 5088 | 902e5 | 3015 3015 |
5089 | 5089 | 8a7ee | 3015 3015 |
5090 | 5090 | 862ed | 3015 3015 |
5091 | 5091 | 225c8 | 3015 3015 |
5092 | 5092 | 3eb1f | 3015 3015 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )