This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
25419 | 25419 | cc5ed | 3246 3246 |
25420 | 25420 | 371f0 | 3246 3246 |
25421 | 25421 | e6200 | 3246 3246 |
25422 | 25422 | b1201 | 3246 3246 |
25423 | 25423 | d9d8c | 3246 3246 |
25424 | 25424 | 154c2 | 3246 3246 |
25425 | 25425 | 5849a | 3246 3246 |
25426 | 25426 | eab5e | 3246 3246 |
25427 | 25427 | 5dcb2 | 3246 3246 |
25428 | 25428 | d3539 | 3246 3246 |
25429 | 25429 | bb97d | 3246 3246 |
25430 | 25430 | 4a957 | 3246 3246 |
25431 | 25431 | 68743 | 3246 3246 |
25432 | 25432 | 4f89e | 3246 3246 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )