This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17281 | 17281 | a8e8b | 3317 3317 |
| 17282 | 17282 | 7b150 | 3317 3317 |
| 17283 | 17283 | 5e075 | 3317 3317 |
| 17284 | 17284 | 59d75 | 3317 3317 |
| 17285 | 17285 | e6200 | 3317 3317 |
| 17286 | 17286 | b1201 | 3317 3317 |
| 17287 | 17287 | 8a7ee | 3317 3317 |
| 17288 | 17288 | 862ed | 3317 3317 |
| 17289 | 17289 | 13ab6 | 3317 3317 |
| 17290 | 17290 | 18a64 | 3317 3317 |
| 17291 | 17291 | 66f82 | 3317 3317 |
| 17292 | 17292 | f788a | 3317 3317 |
| 17293 | 17293 | 7c38f | 3317 3317 |
| 17294 | 17294 | df1f0 | 3317 3317 |
| 17295 | 17295 | a1307 | 3317 3317 |
| 17296 | 17296 | 809af | 3317 3317 |
| 17297 | 17297 | 4225c | 3317 3317 |
| 17298 | 17298 | 93975 | 3317 3317 |
| 17299 | 17299 | 04e82 | 3317 3317 |
| 17300 | 17300 | 94bdc | 3317 3317 |
| 17301 | 17301 | 9c206 | 3317 3317 |
| 17302 | 17302 | 7c580 | 3317 3317 |
| 17303 | 17303 | 724f8 | 3317 3317 |
| 17304 | 17304 | b6f60 | 3317 3317 |
| 17305 | 17305 | 06d39 | 3317 3317 |
| 17306 | 17306 | 2ab82 | 3317 3317 |
| 17307 | 17307 | 8b0bf | 3317 3317 |
| 17308 | 17308 | 01e8a | 3317 3317 |
| 17309 | 17309 | 2aa57 | 3317 3317 |
| 17310 | 17310 | 425d7 | 3317 3317 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)