This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18377 | 18377 | cc5ed | 3256 3256 |
18378 | 18378 | ea4d7 | 3256 3256 |
18379 | 18379 | 2fe0c | 3256 3256 |
18380 | 18380 | 5e075 | 3256 3256 |
18381 | 18381 | 59d75 | 3256 3256 |
18382 | 18382 | e6200 | 3256 3256 |
18383 | 18383 | b1201 | 3256 3256 |
18384 | 18384 | 902e5 | 3256 3256 |
18385 | 18385 | 7dde7 | 3256 3256 |
18386 | 18386 | 26e0c | 3256 3256 |
18387 | 18387 | f3d24 | 3256 3256 |
18388 | 18388 | ff46e | 3256 3256 |
18389 | 18389 | 896d2 | 3256 3256 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )