This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9998 | 9998 | ec3ac | 889 889 |
| 9999 | 9999 | 59b7b | 889 889 |
| 10000 | 10000 | a14cf | 889 889 |
| 10001 | 10001 | 5e075 | 889 889 |
| 10002 | 10002 | 59d75 | 889 889 |
| 10003 | 10003 | e6200 | 889 889 |
| 10004 | 10004 | b1201 | 889 889 |
| 10005 | 10005 | b8d0a | 889 889 |
| 10006 | 10006 | c8e9f | 889 889 |
| 10007 | 10007 | e128e | 889 889 |
| 10008 | 10008 | 598d9 | 889 889 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)