This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4390 | 4390 | ec3ac | 438 438 |
4391 | 4391 | 0b28b | 438 438 |
4392 | 4392 | 72f3e | 438 438 |
4393 | 4393 | 72597 | 438 438 |
4394 | 4394 | 371f0 | 438 438 |
4395 | 4395 | 5e075 | 438 438 |
4396 | 4396 | 59d75 | 438 438 |
4397 | 4397 | e6200 | 438 438 |
4398 | 4398 | b1201 | 438 438 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )