This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32124 | 32124 | b08d4 | 465 465 |
32125 | 32125 | 9527f | 465 465 |
32126 | 32126 | f4bd7 | 465 465 |
32127 | 32127 | ae23f | 465 465 |
32128 | 32128 | 371f0 | 465 465 |
32129 | 32129 | 5e075 | 465 465 |
32130 | 32130 | 59d75 | 465 465 |
32131 | 32131 | e6200 | 465 465 |
32132 | 32132 | b1201 | 465 465 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )