This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11372 | 11372 | ec3ac | 837 837 |
11373 | 11373 | b668a | 837 837 |
11374 | 11374 | aaf5a | 837 837 |
11375 | 11375 | 5e075 | 837 837 |
11376 | 11376 | 59d75 | 837 837 |
11377 | 11377 | e6200 | 837 837 |
11378 | 11378 | b1201 | 837 837 |
11379 | 11379 | 63e96 | 837 837 |
11380 | 11380 | 2fb27 | 837 837 |
11381 | 11381 | 7a351 | 837 837 |
11382 | 11382 | 0593a | 837 837 |
11383 | 11383 | eecd9 | 837 837 |
11384 | 11384 | 7ce59 | 837 837 |
11385 | 11385 | b8d0a | 837 837 |
11386 | 11386 | 3896c | 837 837 |
11387 | 11387 | a524c | 837 837 |
11388 | 11388 | 41ee7 | 837 837 |
11389 | 11389 | ed356 | 837 837 |
11390 | 11390 | 94bdc | 837 837 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )