This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13090 | 13090 | ec3ac | 34 34 |
13091 | 13091 | 95e7c | 34 34 |
13092 | 13092 | 59d75 | 34 34 |
13093 | 13093 | 3502d | 34 34 |
13094 | 13094 | 77672 | 34 34 |
13095 | 13095 | 201fd | 34 34 |
13096 | 13096 | 2095d | 34 34 |
13097 | 13097 | 7e7c6 | 34 34 |
13098 | 13098 | 8355d | 34 34 |
13099 | 13099 | 8751c | 34 34 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )