This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2527 | 2527 | 61345 | 1467 1467 |
2817 | 2817 | 61345 | 1466 1466 |
2865 | 2865 | 61345 | 1468 1468 |
12672 | 12672 | 61345 | 1484 1484 |
13262 | 13262 | 61345 | 1503 1503 |
13291 | 13291 | 61345 | 1494 1494 |
14035 | 14035 | 61345 | 1497 1497 |
14162 | 14162 | 61345 | 1481 1481 |
14428 | 14428 | 61345 | 1455 1455 |
14499 | 14499 | 61345 | 1475 1475 |
14905 | 14905 | 61345 | 1513 1513 |
15503 | 15503 | 61345 | 1506 1506 |
19387 | 19387 | 61345 | 1478 1478 |
20109 | 20109 | 61345 | 1500 1500 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )