This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
29847 | 29847 | ec3ac | 802 802 |
29848 | 29848 | d6ade | 802 802 |
29849 | 29849 | 8e7b3 | 802 802 |
29850 | 29850 | 2dfbd | 802 802 |
29851 | 29851 | ebe26 | 802 802 |
29852 | 29852 | a0f55 | 802 802 |
29853 | 29853 | 63865 | 802 802 |
29854 | 29854 | e6200 | 802 802 |
29855 | 29855 | b1201 | 802 802 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )