This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20983 | 20983 | cc5ed | 2780 2780 |
| 20984 | 20984 | cba3e | 2780 2780 |
| 20985 | 20985 | 2fe0c | 2780 2780 |
| 20986 | 20986 | 5e075 | 2780 2780 |
| 20987 | 20987 | 59d75 | 2780 2780 |
| 20988 | 20988 | 3502d | 2780 2780 |
| 20989 | 20989 | 1c6ee | 2780 2780 |
| 20990 | 20990 | a72cb | 2780 2780 |
| 20991 | 20991 | 4e8fc | 2780 2780 |
| 20992 | 20992 | bafb6 | 2780 2780 |
| 20993 | 20993 | 7fdf0 | 2780 2780 |
| 20994 | 20994 | bcbce | 2780 2780 |
| 20995 | 20995 | a9339 | 2780 2780 |
| 20996 | 20996 | 2827b | 2780 2780 |
| 20997 | 20997 | cf133 | 2780 2780 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)