This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16612 | 16612 | a26ae | 2970 2970 |
| 16613 | 16613 | c3503 | 2970 2970 |
| 16614 | 16614 | cc5ed | 2970 2970 |
| 16615 | 16615 | cb80d | 2970 2970 |
| 16616 | 16616 | 371f0 | 2970 2970 |
| 16617 | 16617 | 59d75 | 2970 2970 |
| 16618 | 16618 | e6200 | 2970 2970 |
| 16619 | 16619 | b1201 | 2970 2970 |
| 16620 | 16620 | 902e5 | 2970 2970 |
| 16621 | 16621 | 7dde7 | 2970 2970 |
| 16622 | 16622 | af0a7 | 2970 2970 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)