This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8202 | 8202 | ec3ac | 2996 2996 |
| 8203 | 8203 | d68b2 | 2996 2996 |
| 8204 | 8204 | dd539 | 2996 2996 |
| 8205 | 8205 | 5e075 | 2996 2996 |
| 8206 | 8206 | 59d75 | 2996 2996 |
| 8207 | 8207 | e6200 | 2996 2996 |
| 8208 | 8208 | b1201 | 2996 2996 |
| 8209 | 8209 | 902e5 | 2996 2996 |
| 8210 | 8210 | d8e92 | 2996 2996 |
| 8211 | 8211 | 83826 | 2996 2996 |
| 8212 | 8212 | e8380 | 2996 2996 |
| 8213 | 8213 | a397e | 2996 2996 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)