This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 35449 | 35449 | 9381b | 1291 1291 |
| 35724 | 35724 | 9381b | 1304 1304 |
| 35756 | 35756 | 9381b | 1418 1418 |
| 35770 | 35770 | 9381b | 1424 1424 |
| 35777 | 35777 | 9381b | 1410 1410 |
| 35784 | 35784 | 9381b | 1412 1412 |
| 35797 | 35797 | 9381b | 1416 1416 |
| 35828 | 35828 | 9381b | 1414 1414 |
| 35835 | 35835 | 9381b | 1323 1323 |
| 35842 | 35842 | 9381b | 1408 1408 |
| 35849 | 35849 | 9381b | 1422 1422 |
| 35881 | 35881 | 9381b | 1420 1420 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)