This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18520 | 18520 | ec3ac | 928 928 |
18521 | 18521 | 4801f | 928 928 |
18522 | 18522 | 5e075 | 928 928 |
18523 | 18523 | 59d75 | 928 928 |
18524 | 18524 | e6200 | 928 928 |
18525 | 18525 | b1201 | 928 928 |
18526 | 18526 | d6347 | 928 928 |
18527 | 18527 | ebf60 | 928 928 |
18528 | 18528 | 9a8c6 | 928 928 |
18529 | 18529 | 91693 | 928 928 |
18530 | 18530 | 1d2ab | 928 928 |
18531 | 18531 | abb72 | 928 928 |
18532 | 18532 | 41b26 | 928 928 |
18533 | 18533 | 2db78 | 928 928 |
18534 | 18534 | 6a38c | 928 928 |
18535 | 18535 | e128e | 928 928 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )