This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36119 | 36119 | cc5ed | 3159 3159 |
| 36120 | 36120 | d6ade | 3159 3159 |
| 36121 | 36121 | 8e7b3 | 3159 3159 |
| 36122 | 36122 | d4179 | 3159 3159 |
| 36123 | 36123 | 313af | 3159 3159 |
| 36124 | 36124 | ebe26 | 3159 3159 |
| 36125 | 36125 | aabe0 | 3159 3159 |
| 36126 | 36126 | a0f55 | 3159 3159 |
| 36127 | 36127 | 371f0 | 3159 3159 |
| 36128 | 36128 | e6200 | 3159 3159 |
| 36129 | 36129 | b1201 | 3159 3159 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)