This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32956 | 32956 | ec3ac | 479 479 |
32957 | 32957 | 9527f | 479 479 |
32958 | 32958 | f4bd7 | 479 479 |
32959 | 32959 | ae23f | 479 479 |
32960 | 32960 | 371f0 | 479 479 |
32961 | 32961 | 5e075 | 479 479 |
32962 | 32962 | 59d75 | 479 479 |
32963 | 32963 | e6200 | 479 479 |
32964 | 32964 | b1201 | 479 479 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )