This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2173 | 2173 | cc5ed | 2985 2985 |
| 2174 | 2174 | 40c27 | 2985 2985 |
| 2175 | 2175 | f4921 | 2985 2985 |
| 2176 | 2176 | 550f6 | 2985 2985 |
| 2177 | 2177 | bb74c | 2985 2985 |
| 2178 | 2178 | aabe0 | 2985 2985 |
| 2179 | 2179 | a06cb | 2985 2985 |
| 2180 | 2180 | 87fac | 2985 2985 |
| 2181 | 2181 | 32c58 | 2985 2985 |
| 2182 | 2182 | 7ceb1 | 2985 2985 |
| 2183 | 2183 | 371f0 | 2985 2985 |
| 2184 | 2184 | e6200 | 2985 2985 |
| 2185 | 2185 | b1201 | 2985 2985 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)