This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15920 | 15920 | a0884 | 3387 3387 |
16046 | 16046 | a0884 | 3386 3386 |
16089 | 16089 | a0884 | 3388 3388 |
16231 | 16231 | a0884 | 3380 3380 |
16676 | 16676 | a0884 | 3385 3385 |
17054 | 17054 | a0884 | 3379 3379 |
36537 | 36537 | a0884 | 1253 1253 |
36563 | 36563 | a0884 | 1258 1258 |
36590 | 36590 | a0884 | 1259 1259 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )