This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
29698 | 29698 | cc5ed | 3228 3228 |
29699 | 29699 | d6ade | 3228 3228 |
29700 | 29700 | 8e7b3 | 3228 3228 |
29701 | 29701 | d1b15 | 3228 3228 |
29702 | 29702 | 5ad28 | 3228 3228 |
29703 | 29703 | c4200 | 3228 3228 |
29704 | 29704 | e0460 | 3228 3228 |
29705 | 29705 | ebe26 | 3228 3228 |
29706 | 29706 | fbbdb | 3228 3228 |
29707 | 29707 | a0f55 | 3228 3228 |
29708 | 29708 | 371f0 | 3228 3228 |
29709 | 29709 | e6200 | 3228 3228 |
29710 | 29710 | 3502d | 3228 3228 |
29711 | 29711 | b1201 | 3228 3228 |
29712 | 29712 | 04629 | 3228 3228 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )