This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16413 | 16413 | cc5ed | 2432 2432 |
16414 | 16414 | 5fc41 | 2432 2432 |
16415 | 16415 | e2dbf | 2432 2432 |
16416 | 16416 | 5e075 | 2432 2432 |
16417 | 16417 | 59d75 | 2432 2432 |
16418 | 16418 | e6200 | 2432 2432 |
16419 | 16419 | b1201 | 2432 2432 |
16420 | 16420 | 1a96d | 2432 2432 |
16421 | 16421 | 8ee70 | 2432 2432 |
16422 | 16422 | 4be0b | 2432 2432 |
16423 | 16423 | cbdd5 | 2432 2432 |
16424 | 16424 | c08cd | 2432 2432 |
16425 | 16425 | bf5f5 | 2432 2432 |
16426 | 16426 | ea908 | 2432 2432 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )