This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4023 | 4023 | 1ef30 | 383 383 |
4024 | 4024 | dd761 | 383 383 |
4025 | 4025 | 0c41e | 383 383 |
4026 | 4026 | d5d33 | 383 383 |
4027 | 4027 | 6fba5 | 383 383 |
4028 | 4028 | 371f0 | 383 383 |
4029 | 4029 | 5e075 | 383 383 |
4030 | 4030 | 59d75 | 383 383 |
4031 | 4031 | e6200 | 383 383 |
4032 | 4032 | b1201 | 383 383 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )