This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34200 | 34200 | ec3ac | 910 910 |
34201 | 34201 | 1c31d | 910 910 |
34202 | 34202 | 5e075 | 910 910 |
34203 | 34203 | 59d75 | 910 910 |
34204 | 34204 | e6200 | 910 910 |
34205 | 34205 | b1201 | 910 910 |
34206 | 34206 | b42a4 | 910 910 |
34207 | 34207 | d679e | 910 910 |
34208 | 34208 | 17bc7 | 910 910 |
34209 | 34209 | aa04d | 910 910 |
34210 | 34210 | 95f91 | 910 910 |
34211 | 34211 | f0dcd | 910 910 |
34212 | 34212 | be4a2 | 910 910 |
34213 | 34213 | d75c0 | 910 910 |
34214 | 34214 | 16071 | 910 910 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )