This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
36380 | 36380 | ec3ac | 3303 3303 |
36381 | 36381 | bcd9a | 3303 3303 |
36382 | 36382 | 371f0 | 3303 3303 |
36383 | 36383 | 5e075 | 3303 3303 |
36384 | 36384 | 59d75 | 3303 3303 |
36385 | 36385 | e6200 | 3303 3303 |
36386 | 36386 | b1201 | 3303 3303 |
36387 | 36387 | 902e5 | 3303 3303 |
36388 | 36388 | 372e7 | 3303 3303 |
36389 | 36389 | bbce5 | 3303 3303 |
36390 | 36390 | 386c6 | 3303 3303 |
36391 | 36391 | f7021 | 3303 3303 |
36392 | 36392 | cf71d | 3303 3303 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )