This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9615 | 9615 | 53703 | 1464 1464 |
10087 | 10087 | 53703 | 1451 1451 |
10515 | 10515 | 53703 | 1437 1437 |
10547 | 10547 | 53703 | 1436 1436 |
10560 | 10560 | 53703 | 1440 1440 |
10599 | 10599 | 53703 | 1447 1447 |
10612 | 10612 | 53703 | 1454 1454 |
10656 | 10656 | 53703 | 1445 1445 |
10685 | 10685 | 53703 | 1438 1438 |
10713 | 10713 | 53703 | 1446 1446 |
10726 | 10726 | 53703 | 1453 1453 |
10875 | 10875 | 53703 | 1444 1444 |
10894 | 10894 | 53703 | 1448 1448 |
11155 | 11155 | 53703 | 1452 1452 |
11174 | 11174 | 53703 | 1450 1450 |
11238 | 11238 | 53703 | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )