This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9607 | 9607 | cc756 | 1464 1464 |
10079 | 10079 | cc756 | 1451 1451 |
10507 | 10507 | cc756 | 1437 1437 |
10539 | 10539 | cc756 | 1436 1436 |
10552 | 10552 | cc756 | 1440 1440 |
10591 | 10591 | cc756 | 1447 1447 |
10604 | 10604 | cc756 | 1454 1454 |
10648 | 10648 | cc756 | 1445 1445 |
10677 | 10677 | cc756 | 1438 1438 |
10705 | 10705 | cc756 | 1446 1446 |
10718 | 10718 | cc756 | 1453 1453 |
10867 | 10867 | cc756 | 1444 1444 |
10886 | 10886 | cc756 | 1448 1448 |
11147 | 11147 | cc756 | 1452 1452 |
11166 | 11166 | cc756 | 1450 1450 |
11230 | 11230 | cc756 | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )