This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2357 | 2357 | 6f57d | 544 544 |
| 4523 | 4523 | 6f57d | 669 669 |
| 4643 | 4643 | 6f57d | 581 581 |
| 4709 | 4709 | 6f57d | 671 671 |
| 4832 | 4832 | 6f57d | 674 674 |
| 18658 | 18658 | 6f57d | 1260 1260 |
| 31023 | 31023 | 6f57d | 1874 1874 |
| 31098 | 31098 | 6f57d | 1875 1875 |
| 35628 | 35628 | 6f57d | 1 1 |
| 35721 | 35721 | 6f57d | 1251 1251 |
| 35766 | 35766 | 6f57d | 1252 1252 |
| 36642 | 36642 | 6f57d | 1255 1255 |
| 36677 | 36677 | 6f57d | 1256 1256 |
| 36718 | 36718 | 6f57d | 1254 1254 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)