This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33589 | 33589 | ec3ac | 924 924 |
33590 | 33590 | b668a | 924 924 |
33591 | 33591 | aaf5a | 924 924 |
33592 | 33592 | 5e075 | 924 924 |
33593 | 33593 | 59d75 | 924 924 |
33594 | 33594 | e6200 | 924 924 |
33595 | 33595 | b1201 | 924 924 |
33596 | 33596 | b42a4 | 924 924 |
33597 | 33597 | d679e | 924 924 |
33598 | 33598 | 17bc7 | 924 924 |
33599 | 33599 | aa04d | 924 924 |
33600 | 33600 | 95f91 | 924 924 |
33601 | 33601 | 7ce59 | 924 924 |
33602 | 33602 | a524c | 924 924 |
33603 | 33603 | 234f1 | 924 924 |
33604 | 33604 | 100b7 | 924 924 |
33605 | 33605 | 1518e | 924 924 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )