This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5037 | 5037 | db8b3 | 2755 2755 |
| 5051 | 5051 | db8b3 | 2749 2749 |
| 5100 | 5100 | db8b3 | 2745 2745 |
| 5471 | 5471 | db8b3 | 2754 2754 |
| 5513 | 5513 | db8b3 | 2744 2744 |
| 6081 | 6081 | db8b3 | 2748 2748 |
| 6167 | 6167 | db8b3 | 2746 2746 |
| 6345 | 6345 | db8b3 | 2747 2747 |
| 6364 | 6364 | db8b3 | 2751 2751 |
| 6884 | 6884 | db8b3 | 2762 2762 |
| 6962 | 6962 | db8b3 | 2756 2756 |
| 7151 | 7151 | db8b3 | 2757 2757 |
| 7589 | 7589 | db8b3 | 2759 2759 |
| 7720 | 7720 | db8b3 | 2742 2742 |
| 7852 | 7852 | db8b3 | 2743 2743 |
| 8051 | 8051 | db8b3 | 2758 2758 |
| 8169 | 8169 | db8b3 | 2760 2760 |
| 9711 | 9711 | db8b3 | 1941 1941 |
| 12068 | 12068 | db8b3 | 1944 1944 |
| 31986 | 31986 | db8b3 | 1929 1929 |
| 34592 | 34592 | db8b3 | 1930 1930 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)