This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11136 | 11136 | ec3ac | 1369 1369 |
11137 | 11137 | ea4d7 | 1369 1369 |
11138 | 11138 | 685a3 | 1369 1369 |
11139 | 11139 | 5e075 | 1369 1369 |
11140 | 11140 | 59d75 | 1369 1369 |
11141 | 11141 | e6200 | 1369 1369 |
11142 | 11142 | b1201 | 1369 1369 |
11143 | 11143 | 40a6c | 1369 1369 |
11144 | 11144 | f03e5 | 1369 1369 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )