This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7173 | 7173 | cc5ed | 2973 2973 |
| 7174 | 7174 | 371f0 | 2973 2973 |
| 7175 | 7175 | e6200 | 2973 2973 |
| 7176 | 7176 | b1201 | 2973 2973 |
| 7177 | 7177 | 902e5 | 2973 2973 |
| 7178 | 7178 | 5d37b | 2973 2973 |
| 7179 | 7179 | 188e8 | 2973 2973 |
| 7180 | 7180 | 46c5b | 2973 2973 |
| 7181 | 7181 | 5d35f | 2973 2973 |
| 7182 | 7182 | 13e72 | 2973 2973 |
| 7183 | 7183 | 50b3d | 2973 2973 |
| 7184 | 7184 | b4886 | 2973 2973 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)