This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31982 | 31982 | cc5ed | 1929 1929 |
| 31983 | 31983 | 371f0 | 1929 1929 |
| 31984 | 31984 | 59d75 | 1929 1929 |
| 31985 | 31985 | 3502d | 1929 1929 |
| 31986 | 31986 | db8b3 | 1929 1929 |
| 31987 | 31987 | 42004 | 1929 1929 |
| 31988 | 31988 | e6fee | 1929 1929 |
| 31989 | 31989 | 6acab | 1929 1929 |
| 31990 | 31990 | ac3f7 | 1929 1929 |
| 31991 | 31991 | 1e955 | 1929 1929 |
| 31992 | 31992 | 8bee9 | 1929 1929 |
| 31993 | 31993 | e5b4a | 1929 1929 |
| 31994 | 31994 | 21a80 | 1929 1929 |
| 31995 | 31995 | 009ee | 1929 1929 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)