This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6745 | 6745 | ec3ac | 1166 1166 |
| 6746 | 6746 | 17183 | 1166 1166 |
| 6747 | 6747 | 96bbd | 1166 1166 |
| 6748 | 6748 | d4179 | 1166 1166 |
| 6749 | 6749 | 313af | 1166 1166 |
| 6750 | 6750 | ebe26 | 1166 1166 |
| 6751 | 6751 | aabe0 | 1166 1166 |
| 6752 | 6752 | 9e07c | 1166 1166 |
| 6753 | 6753 | 1073c | 1166 1166 |
| 6754 | 6754 | c3b9b | 1166 1166 |
| 6755 | 6755 | 5e075 | 1166 1166 |
| 6756 | 6756 | 59d75 | 1166 1166 |
| 6757 | 6757 | e6200 | 1166 1166 |
| 6758 | 6758 | b1201 | 1166 1166 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)