This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34588 | 34588 | ec3ac | 1930 1930 |
34589 | 34589 | 371f0 | 1930 1930 |
34590 | 34590 | 59d75 | 1930 1930 |
34591 | 34591 | 3502d | 1930 1930 |
34592 | 34592 | db8b3 | 1930 1930 |
34593 | 34593 | 42004 | 1930 1930 |
34594 | 34594 | dd28e | 1930 1930 |
34595 | 34595 | 19a58 | 1930 1930 |
34596 | 34596 | 3d056 | 1930 1930 |
34597 | 34597 | e6fee | 1930 1930 |
34598 | 34598 | e6d79 | 1930 1930 |
34599 | 34599 | 2a4f4 | 1930 1930 |
34600 | 34600 | f2beb | 1930 1930 |
34601 | 34601 | 6acab | 1930 1930 |
34602 | 34602 | cca0f | 1930 1930 |
34603 | 34603 | ac3f7 | 1930 1930 |
34604 | 34604 | 1e955 | 1930 1930 |
34605 | 34605 | e5b4a | 1930 1930 |
34606 | 34606 | 21a80 | 1930 1930 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )