This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
25139 | 25139 | cc5ed | 2935 2935 |
25140 | 25140 | c1190 | 2935 2935 |
25141 | 25141 | cb80d | 2935 2935 |
25142 | 25142 | 371f0 | 2935 2935 |
25143 | 25143 | bf1e7 | 2935 2935 |
25144 | 25144 | e6200 | 2935 2935 |
25145 | 25145 | b1201 | 2935 2935 |
25146 | 25146 | 902e5 | 2935 2935 |
25147 | 25147 | bc1ac | 2935 2935 |
25148 | 25148 | 6ec75 | 2935 2935 |
25149 | 25149 | 5b456 | 2935 2935 |
25150 | 25150 | 77d7e | 2935 2935 |
25151 | 25151 | c46d7 | 2935 2935 |
25152 | 25152 | e5437 | 2935 2935 |
25153 | 25153 | 469ba | 2935 2935 |
25154 | 25154 | 5be59 | 2935 2935 |
25155 | 25155 | ed59f | 2935 2935 |
25156 | 25156 | 1aa29 | 2935 2935 |
25157 | 25157 | 87529 | 2935 2935 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )