This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
29463 | 29463 | cc5ed | 3220 3220 |
29464 | 29464 | d6ade | 3220 3220 |
29465 | 29465 | 8e7b3 | 3220 3220 |
29466 | 29466 | d1b15 | 3220 3220 |
29467 | 29467 | 5ad28 | 3220 3220 |
29468 | 29468 | c4200 | 3220 3220 |
29469 | 29469 | e0460 | 3220 3220 |
29470 | 29470 | ebe26 | 3220 3220 |
29471 | 29471 | fbbdb | 3220 3220 |
29472 | 29472 | a0f55 | 3220 3220 |
29473 | 29473 | 371f0 | 3220 3220 |
29474 | 29474 | e6200 | 3220 3220 |
29475 | 29475 | 3502d | 3220 3220 |
29476 | 29476 | b1201 | 3220 3220 |
29477 | 29477 | 04629 | 3220 3220 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )