This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 985 | 985 | ec3ac | 3007 3007 |
| 986 | 986 | 6060b | 3007 3007 |
| 987 | 987 | 371f0 | 3007 3007 |
| 988 | 988 | 59d75 | 3007 3007 |
| 989 | 989 | e6200 | 3007 3007 |
| 990 | 990 | b1201 | 3007 3007 |
| 991 | 991 | 902e5 | 3007 3007 |
| 992 | 992 | 8a7ee | 3007 3007 |
| 993 | 993 | 862ed | 3007 3007 |
| 994 | 994 | 4d5c2 | 3007 3007 |
| 995 | 995 | 6a9d7 | 3007 3007 |
| 996 | 996 | 225c8 | 3007 3007 |
| 997 | 997 | 466b8 | 3007 3007 |
| 998 | 998 | a1307 | 3007 3007 |
| 999 | 999 | 9fce9 | 3007 3007 |
| 1000 | 1000 | 1518e | 3007 3007 |
| 1001 | 1001 | 9ca51 | 3007 3007 |
| 1002 | 1002 | 509a9 | 3007 3007 |
| 1003 | 1003 | d8584 | 3007 3007 |
| 1004 | 1004 | 9a6db | 3007 3007 |
| 1005 | 1005 | dce58 | 3007 3007 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)