This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 35346 | 35346 | cc5ed | 1998 1998 |
| 35347 | 35347 | d6ade | 1998 1998 |
| 35348 | 35348 | 8e7b3 | 1998 1998 |
| 35349 | 35349 | 313af | 1998 1998 |
| 35350 | 35350 | ebe26 | 1998 1998 |
| 35351 | 35351 | a0f55 | 1998 1998 |
| 35352 | 35352 | cdb88 | 1998 1998 |
| 35353 | 35353 | 371f0 | 1998 1998 |
| 35354 | 35354 | e6200 | 1998 1998 |
| 35355 | 35355 | b1201 | 1998 1998 |
| 35356 | 35356 | 902e5 | 1998 1998 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)