This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2349 | 2349 | 59677 | 1211 1211 |
2588 | 2588 | 59677 | 1205 1205 |
2654 | 2654 | 59677 | 1147 1147 |
2951 | 2951 | 59677 | 1193 1193 |
2963 | 2963 | 59677 | 1199 1199 |
9016 | 9016 | 59677 | 1217 1217 |
35472 | 35472 | 59677 | 1213 1213 |
35500 | 35500 | 59677 | 1207 1207 |
35514 | 35514 | 59677 | 1214 1214 |
35540 | 35540 | 59677 | 1206 1206 |
35561 | 35561 | 59677 | 1212 1212 |
35576 | 35576 | 59677 | 1208 1208 |
35677 | 35677 | 59677 | 1202 1202 |
35705 | 35705 | 59677 | 1196 1196 |
35748 | 35748 | 59677 | 1148 1148 |
35816 | 35816 | 59677 | 1201 1201 |
35873 | 35873 | 59677 | 1150 1150 |
35895 | 35895 | 59677 | 1195 1195 |
35912 | 35912 | 59677 | 1194 1194 |
35937 | 35937 | 59677 | 1200 1200 |
35952 | 35952 | 59677 | 1149 1149 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )