This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1166 | 1166 | ec3ac | 774 774 |
1167 | 1167 | d6ade | 774 774 |
1168 | 1168 | 8e7b3 | 774 774 |
1169 | 1169 | 313af | 774 774 |
1170 | 1170 | ebe26 | 774 774 |
1171 | 1171 | a0f55 | 774 774 |
1172 | 1172 | 61c1a | 774 774 |
1173 | 1173 | e6200 | 774 774 |
1174 | 1174 | b1201 | 774 774 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )