This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3885 | 3885 | d2054 | 64 64 |
3886 | 3886 | cde0d | 64 64 |
3887 | 3887 | 1ef30 | 64 64 |
3888 | 3888 | 52fc7 | 64 64 |
3889 | 3889 | dd761 | 64 64 |
3890 | 3890 | a1ac8 | 64 64 |
3891 | 3891 | 0250c | 64 64 |
3892 | 3892 | c71fb | 64 64 |
3893 | 3893 | 4ba69 | 64 64 |
3894 | 3894 | d5d33 | 64 64 |
3895 | 3895 | 04bf8 | 64 64 |
3896 | 3896 | 6fba5 | 64 64 |
3897 | 3897 | 371f0 | 64 64 |
3898 | 3898 | 5e075 | 64 64 |
3899 | 3899 | 59d75 | 64 64 |
3900 | 3900 | e6200 | 64 64 |
3901 | 3901 | b1201 | 64 64 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )