This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9616 | 9616 | ec55d | 1464 1464 |
10088 | 10088 | ec55d | 1451 1451 |
10516 | 10516 | ec55d | 1437 1437 |
10548 | 10548 | ec55d | 1436 1436 |
10561 | 10561 | ec55d | 1440 1440 |
10600 | 10600 | ec55d | 1447 1447 |
10613 | 10613 | ec55d | 1454 1454 |
10657 | 10657 | ec55d | 1445 1445 |
10686 | 10686 | ec55d | 1438 1438 |
10714 | 10714 | ec55d | 1446 1446 |
10727 | 10727 | ec55d | 1453 1453 |
10876 | 10876 | ec55d | 1444 1444 |
10895 | 10895 | ec55d | 1448 1448 |
11156 | 11156 | ec55d | 1452 1452 |
11175 | 11175 | ec55d | 1450 1450 |
11239 | 11239 | ec55d | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )