This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16108 | 16108 | c17b5 | 3329 3329 |
16109 | 16109 | 371f0 | 3329 3329 |
16110 | 16110 | 5e075 | 3329 3329 |
16111 | 16111 | 59d75 | 3329 3329 |
16112 | 16112 | e6200 | 3329 3329 |
16113 | 16113 | b1201 | 3329 3329 |
16114 | 16114 | a50f7 | 3329 3329 |
16115 | 16115 | d5ec6 | 3329 3329 |
16116 | 16116 | d3559 | 3329 3329 |
16117 | 16117 | 649a5 | 3329 3329 |
16118 | 16118 | 10d3d | 3329 3329 |
16119 | 16119 | b1e1d | 3329 3329 |
16120 | 16120 | 03778 | 3329 3329 |
16121 | 16121 | a1f8b | 3329 3329 |
16122 | 16122 | 37724 | 3329 3329 |
16123 | 16123 | 32bde | 3329 3329 |
16124 | 16124 | 06ae5 | 3329 3329 |
16125 | 16125 | 710d1 | 3329 3329 |
16126 | 16126 | 943de | 3329 3329 |
16127 | 16127 | 8d650 | 3329 3329 |
16128 | 16128 | fa448 | 3329 3329 |
16129 | 16129 | e1dcf | 3329 3329 |
16130 | 16130 | f58f7 | 3329 3329 |
16131 | 16131 | 6e6b8 | 3329 3329 |
16132 | 16132 | e737a | 3329 3329 |
16133 | 16133 | e7176 | 3329 3329 |
16134 | 16134 | c45c4 | 3329 3329 |
16135 | 16135 | 2ed38 | 3329 3329 |
16136 | 16136 | 60bee | 3329 3329 |
16137 | 16137 | 962c9 | 3329 3329 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )