This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24053 | 24053 | cc5ed | 2916 2916 |
| 24054 | 24054 | c1190 | 2916 2916 |
| 24055 | 24055 | cb80d | 2916 2916 |
| 24056 | 24056 | 371f0 | 2916 2916 |
| 24057 | 24057 | bf1e7 | 2916 2916 |
| 24058 | 24058 | e6200 | 2916 2916 |
| 24059 | 24059 | b1201 | 2916 2916 |
| 24060 | 24060 | 902e5 | 2916 2916 |
| 24061 | 24061 | bc1ac | 2916 2916 |
| 24062 | 24062 | 6ec75 | 2916 2916 |
| 24063 | 24063 | 5b456 | 2916 2916 |
| 24064 | 24064 | 77d7e | 2916 2916 |
| 24065 | 24065 | 88f4a | 2916 2916 |
| 24066 | 24066 | ed59f | 2916 2916 |
| 24067 | 24067 | b4bbb | 2916 2916 |
| 24068 | 24068 | 1aa29 | 2916 2916 |
| 24069 | 24069 | 51ad1 | 2916 2916 |
| 24070 | 24070 | b0c29 | 2916 2916 |
| 24071 | 24071 | 87529 | 2916 2916 |
| 24072 | 24072 | 1d7a4 | 2916 2916 |
| 24073 | 24073 | 266f1 | 2916 2916 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)