This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34377 | 34377 | ec3ac | 808 808 |
34378 | 34378 | b668a | 808 808 |
34379 | 34379 | a14cf | 808 808 |
34380 | 34380 | 5e075 | 808 808 |
34381 | 34381 | 59d75 | 808 808 |
34382 | 34382 | e6200 | 808 808 |
34383 | 34383 | b1201 | 808 808 |
34384 | 34384 | b42a4 | 808 808 |
34385 | 34385 | d679e | 808 808 |
34386 | 34386 | 17bc7 | 808 808 |
34387 | 34387 | aa04d | 808 808 |
34388 | 34388 | 95f91 | 808 808 |
34389 | 34389 | f0dcd | 808 808 |
34390 | 34390 | e128e | 808 808 |
34391 | 34391 | d75c0 | 808 808 |
34392 | 34392 | 16071 | 808 808 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )