This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1291 | 1291 | cc5ed | 3072 3072 |
1292 | 1292 | d6ade | 3072 3072 |
1293 | 1293 | 8e7b3 | 3072 3072 |
1294 | 1294 | ebede | 3072 3072 |
1295 | 1295 | e6034 | 3072 3072 |
1296 | 1296 | 313af | 3072 3072 |
1297 | 1297 | f9cc2 | 3072 3072 |
1298 | 1298 | a0f55 | 3072 3072 |
1299 | 1299 | 81536 | 3072 3072 |
1300 | 1300 | 3bf90 | 3072 3072 |
1301 | 1301 | 2f957 | 3072 3072 |
1302 | 1302 | 7b150 | 3072 3072 |
1303 | 1303 | e6200 | 3072 3072 |
1304 | 1304 | b1201 | 3072 3072 |
1305 | 1305 | 04629 | 3072 3072 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )