This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5176 | 5176 | c237c | 692 692 |
| 5606 | 5606 | c237c | 693 693 |
| 6053 | 6053 | c237c | 691 691 |
| 6789 | 6789 | c237c | 687 687 |
| 7125 | 7125 | c237c | 688 688 |
| 7606 | 7606 | c237c | 686 686 |
| 7628 | 7628 | c237c | 680 680 |
| 8072 | 8072 | c237c | 679 679 |
| 12307 | 12307 | c237c | 689 689 |
| 12312 | 12312 | c237c | 683 683 |
| 12378 | 12378 | c237c | 682 682 |
| 12392 | 12392 | c237c | 684 684 |
| 12468 | 12468 | c237c | 678 678 |
| 12584 | 12584 | c237c | 681 681 |
| 18659 | 18659 | c237c | 1260 1260 |
| 30568 | 30568 | c237c | 690 690 |
| 30959 | 30959 | c237c | 685 685 |
| 32805 | 32805 | c237c | 1956 1956 |
| 33040 | 33040 | c237c | 1955 1955 |
| 36643 | 36643 | c237c | 1255 1255 |
| 36678 | 36678 | c237c | 1256 1256 |
| 36719 | 36719 | c237c | 1254 1254 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)