This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
7373 | 7373 | ec3ac | 1165 1165 |
7374 | 7374 | 17183 | 1165 1165 |
7375 | 7375 | 96bbd | 1165 1165 |
7376 | 7376 | d4179 | 1165 1165 |
7377 | 7377 | 313af | 1165 1165 |
7378 | 7378 | ebe26 | 1165 1165 |
7379 | 7379 | c3780 | 1165 1165 |
7380 | 7380 | aabe0 | 1165 1165 |
7381 | 7381 | e38cb | 1165 1165 |
7382 | 7382 | 1073c | 1165 1165 |
7383 | 7383 | 4801f | 1165 1165 |
7384 | 7384 | 5e075 | 1165 1165 |
7385 | 7385 | 59d75 | 1165 1165 |
7386 | 7386 | e6200 | 1165 1165 |
7387 | 7387 | b1201 | 1165 1165 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )