This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27908 | 27908 | cc5ed | 2462 2462 |
| 27909 | 27909 | 7b150 | 2462 2462 |
| 27910 | 27910 | e6200 | 2462 2462 |
| 27911 | 27911 | b1201 | 2462 2462 |
| 27912 | 27912 | 8a7ee | 2462 2462 |
| 27913 | 27913 | 862ed | 2462 2462 |
| 27914 | 27914 | d1aa5 | 2462 2462 |
| 27915 | 27915 | 2ce65 | 2462 2462 |
| 27916 | 27916 | 7746b | 2462 2462 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)