This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 14742 | 14742 | ec3ac | 6 6 |
| 14743 | 14743 | fbe53 | 6 6 |
| 14744 | 14744 | 59d75 | 6 6 |
| 14745 | 14745 | 3502d | 6 6 |
| 14746 | 14746 | a755b | 6 6 |
| 14747 | 14747 | 87070 | 6 6 |
| 14748 | 14748 | 86f51 | 6 6 |
| 14749 | 14749 | 0c5c0 | 6 6 |
| 14750 | 14750 | a44f5 | 6 6 |
| 14751 | 14751 | 88b57 | 6 6 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)