This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9928 | 9928 | 74353 | 235 235 |
| 10666 | 10666 | 74353 | 234 234 |
| 11940 | 11940 | 74353 | 310 310 |
| 12161 | 12161 | 74353 | 183 183 |
| 12250 | 12250 | 74353 | 859 859 |
| 12274 | 12274 | 74353 | 181 181 |
| 12397 | 12397 | 74353 | 186 186 |
| 12417 | 12417 | 74353 | 72 72 |
| 12938 | 12938 | 74353 | 253 253 |
| 13188 | 13188 | 74353 | 244 244 |
| 13339 | 13339 | 74353 | 245 245 |
| 14151 | 14151 | 74353 | 241 241 |
| 14211 | 14211 | 74353 | 250 250 |
| 14719 | 14719 | 74353 | 243 243 |
| 31725 | 31725 | 74353 | 298 298 |
| 31750 | 31750 | 74353 | 286 286 |
| 31978 | 31978 | 74353 | 102 102 |
| 32144 | 32144 | 74353 | 103 103 |
| 33536 | 33536 | 74353 | 847 847 |
| 33772 | 33772 | 74353 | 905 905 |
| 34437 | 34437 | 74353 | 788 788 |
| 34873 | 34873 | 74353 | 299 299 |
| 35284 | 35284 | 74353 | 104 104 |
| 35425 | 35425 | 74353 | 65 65 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)