This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29989 | 29989 | ec3ac | 1088 1088 |
| 29990 | 29990 | 4801f | 1088 1088 |
| 29991 | 29991 | 5e075 | 1088 1088 |
| 29992 | 29992 | 59d75 | 1088 1088 |
| 29993 | 29993 | e6200 | 1088 1088 |
| 29994 | 29994 | b1201 | 1088 1088 |
| 29995 | 29995 | d6347 | 1088 1088 |
| 29996 | 29996 | ebf60 | 1088 1088 |
| 29997 | 29997 | 9a8c6 | 1088 1088 |
| 29998 | 29998 | 91693 | 1088 1088 |
| 29999 | 29999 | 1d2ab | 1088 1088 |
| 30000 | 30000 | abb72 | 1088 1088 |
| 30001 | 30001 | 41b26 | 1088 1088 |
| 30002 | 30002 | 2db78 | 1088 1088 |
| 30003 | 30003 | 6a38c | 1088 1088 |
| 30004 | 30004 | e128e | 1088 1088 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)