This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18645 | 18645 | 95484 | 1260 1260 |
31063 | 31063 | 95484 | 15 15 |
31914 | 31914 | 95484 | 1298 1298 |
32220 | 32220 | 95484 | 1314 1314 |
32803 | 32803 | 95484 | 1956 1956 |
33038 | 33038 | 95484 | 1955 1955 |
34918 | 34918 | 95484 | 1293 1293 |
35244 | 35244 | 95484 | 1957 1957 |
35434 | 35434 | 95484 | 1328 1328 |
36629 | 36629 | 95484 | 1255 1255 |
36664 | 36664 | 95484 | 1256 1256 |
36705 | 36705 | 95484 | 1254 1254 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )