This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
19425 | 19425 | cc5ed | 3255 3255 |
19426 | 19426 | ea4d7 | 3255 3255 |
19427 | 19427 | e7d5b | 3255 3255 |
19428 | 19428 | 5e075 | 3255 3255 |
19429 | 19429 | 59d75 | 3255 3255 |
19430 | 19430 | e6200 | 3255 3255 |
19431 | 19431 | b1201 | 3255 3255 |
19432 | 19432 | 902e5 | 3255 3255 |
19433 | 19433 | 61f36 | 3255 3255 |
19434 | 19434 | 8123a | 3255 3255 |
19435 | 19435 | 66635 | 3255 3255 |
19436 | 19436 | 8751c | 3255 3255 |
19437 | 19437 | ff46e | 3255 3255 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )