This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26798 | 26798 | cc5ed | 3170 3170 |
| 26799 | 26799 | d6ade | 3170 3170 |
| 26800 | 26800 | 8e7b3 | 3170 3170 |
| 26801 | 26801 | c1ffd | 3170 3170 |
| 26802 | 26802 | 2dfbd | 3170 3170 |
| 26803 | 26803 | 4e7f1 | 3170 3170 |
| 26804 | 26804 | aabe0 | 3170 3170 |
| 26805 | 26805 | a0f55 | 3170 3170 |
| 26806 | 26806 | 371f0 | 3170 3170 |
| 26807 | 26807 | e6200 | 3170 3170 |
| 26808 | 26808 | b1201 | 3170 3170 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)