This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 719 | 719 | c3b9b | 1095 1095 |
| 6754 | 6754 | c3b9b | 1166 1166 |
| 7877 | 7877 | c3b9b | 1164 1164 |
| 16477 | 16477 | c3b9b | 1137 1137 |
| 17014 | 17014 | c3b9b | 1186 1186 |
| 17559 | 17559 | c3b9b | 1040 1040 |
| 17642 | 17642 | c3b9b | 1133 1133 |
| 20322 | 20322 | c3b9b | 943 943 |
| 21971 | 21971 | c3b9b | 1013 1013 |
| 22821 | 22821 | c3b9b | 1011 1011 |
| 27548 | 27548 | c3b9b | 946 946 |
| 28774 | 28774 | c3b9b | 1029 1029 |
| 30121 | 30121 | c3b9b | 1032 1032 |
| 36426 | 36426 | c3b9b | 1054 1054 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)