This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16147 | 16147 | cc5ed | 3131 3131 |
16148 | 16148 | d6ade | 3131 3131 |
16149 | 16149 | 8e7b3 | 3131 3131 |
16150 | 16150 | 2dfbd | 3131 3131 |
16151 | 16151 | ebe26 | 3131 3131 |
16152 | 16152 | a0f55 | 3131 3131 |
16153 | 16153 | 371f0 | 3131 3131 |
16154 | 16154 | e6200 | 3131 3131 |
16155 | 16155 | b1201 | 3131 3131 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )