This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7055 | 7055 | ec3ac | 1072 1072 |
| 7056 | 7056 | 17183 | 1072 1072 |
| 7057 | 7057 | 96bbd | 1072 1072 |
| 7058 | 7058 | 550f6 | 1072 1072 |
| 7059 | 7059 | 343d8 | 1072 1072 |
| 7060 | 7060 | e0460 | 1072 1072 |
| 7061 | 7061 | 02db8 | 1072 1072 |
| 7062 | 7062 | aabe0 | 1072 1072 |
| 7063 | 7063 | 3e5f6 | 1072 1072 |
| 7064 | 7064 | 87fac | 1072 1072 |
| 7065 | 7065 | 1073c | 1072 1072 |
| 7066 | 7066 | 4801f | 1072 1072 |
| 7067 | 7067 | 5e075 | 1072 1072 |
| 7068 | 7068 | 59d75 | 1072 1072 |
| 7069 | 7069 | e6200 | 1072 1072 |
| 7070 | 7070 | b1201 | 1072 1072 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)