This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 171 | 171 | 3e5f6 | 1098 1098 |
| 716 | 716 | 3e5f6 | 1095 1095 |
| 1235 | 1235 | 3e5f6 | 1045 1045 |
| 1408 | 1408 | 3e5f6 | 1179 1179 |
| 1455 | 1455 | 3e5f6 | 1057 1057 |
| 1471 | 1471 | 3e5f6 | 1070 1070 |
| 1800 | 1800 | 3e5f6 | 1074 1074 |
| 2044 | 2044 | 3e5f6 | 1041 1041 |
| 2141 | 2141 | 3e5f6 | 1021 1021 |
| 5197 | 5197 | 3e5f6 | 1092 1092 |
| 6869 | 6869 | 3e5f6 | 1071 1071 |
| 6922 | 6922 | 3e5f6 | 1061 1061 |
| 7063 | 7063 | 3e5f6 | 1072 1072 |
| 7870 | 7870 | 3e5f6 | 1164 1164 |
| 8089 | 8089 | 3e5f6 | 1052 1052 |
| 8233 | 8233 | 3e5f6 | 0 0 |
| 30304 | 30304 | 3e5f6 | 1176 1176 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)