This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33268 | 33268 | e0435 | 1920 1920 |
33269 | 33269 | be9a7 | 1920 1920 |
33270 | 33270 | 59d75 | 1920 1920 |
33271 | 33271 | 3502d | 1920 1920 |
33272 | 33272 | 03f36 | 1920 1920 |
33273 | 33273 | ffedb | 1920 1920 |
33274 | 33274 | 7be59 | 1920 1920 |
33275 | 33275 | 5fea6 | 1920 1920 |
33276 | 33276 | 9d42d | 1920 1920 |
33277 | 33277 | 0d016 | 1920 1920 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )