This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16409 | 16409 | 376eb | 3338 3338 |
17781 | 17781 | 376eb | 3340 3340 |
24525 | 24525 | 376eb | 3318 3318 |
25970 | 25970 | 376eb | 3362 3362 |
26192 | 26192 | 376eb | 3326 3326 |
27384 | 27384 | 376eb | 3339 3339 |
27820 | 27820 | 376eb | 3322 3322 |
27960 | 27960 | 376eb | 3361 3361 |
28056 | 28056 | 376eb | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )