This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1068 | 1068 | cc5ed | 2992 2992 |
| 1069 | 1069 | 313af | 2992 2992 |
| 1070 | 1070 | 2cd39 | 2992 2992 |
| 1071 | 1071 | 7ceb1 | 2992 2992 |
| 1072 | 1072 | 371f0 | 2992 2992 |
| 1073 | 1073 | e6200 | 2992 2992 |
| 1074 | 1074 | b1201 | 2992 2992 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)