This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
253 | 253 | 45c5d | 3200 3200 |
643 | 643 | 45c5d | 3201 3201 |
17671 | 17671 | 45c5d | 3214 3214 |
28499 | 28499 | 45c5d | 3204 3204 |
28650 | 28650 | 45c5d | 3205 3205 |
28674 | 28674 | 45c5d | 3203 3203 |
29387 | 29387 | 45c5d | 3202 3202 |
29761 | 29761 | 45c5d | 3212 3212 |
29809 | 29809 | 45c5d | 3208 3208 |
29940 | 29940 | 45c5d | 3210 3210 |
30171 | 30171 | 45c5d | 3207 3207 |
30363 | 30363 | 45c5d | 3211 3211 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )