This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28837 | 28837 | ec3ac | 3180 3180 |
28838 | 28838 | 13c3e | 3180 3180 |
28839 | 28839 | 371f0 | 3180 3180 |
28840 | 28840 | e6200 | 3180 3180 |
28841 | 28841 | b1201 | 3180 3180 |
28842 | 28842 | 902e5 | 3180 3180 |
28843 | 28843 | bc1ac | 3180 3180 |
28844 | 28844 | 6ec75 | 3180 3180 |
28845 | 28845 | 5b456 | 3180 3180 |
28846 | 28846 | 77d7e | 3180 3180 |
28847 | 28847 | c46d7 | 3180 3180 |
28848 | 28848 | e5437 | 3180 3180 |
28849 | 28849 | b3b48 | 3180 3180 |
28850 | 28850 | 469ba | 3180 3180 |
28851 | 28851 | feaa7 | 3180 3180 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )