This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18029 | 18029 | c4d21 | 3360 3360 |
| 18030 | 18030 | 7b150 | 3360 3360 |
| 18031 | 18031 | e6200 | 3360 3360 |
| 18032 | 18032 | b1201 | 3360 3360 |
| 18033 | 18033 | 8a7ee | 3360 3360 |
| 18034 | 18034 | 862ed | 3360 3360 |
| 18035 | 18035 | 18a64 | 3360 3360 |
| 18036 | 18036 | 66f82 | 3360 3360 |
| 18037 | 18037 | 7c38f | 3360 3360 |
| 18038 | 18038 | 91693 | 3360 3360 |
| 18039 | 18039 | 1d2ab | 3360 3360 |
| 18040 | 18040 | 809af | 3360 3360 |
| 18041 | 18041 | abb72 | 3360 3360 |
| 18042 | 18042 | 93975 | 3360 3360 |
| 18043 | 18043 | fec0a | 3360 3360 |
| 18044 | 18044 | 94bdc | 3360 3360 |
| 18045 | 18045 | 9c206 | 3360 3360 |
| 18046 | 18046 | 7c580 | 3360 3360 |
| 18047 | 18047 | d27ad | 3360 3360 |
| 18048 | 18048 | 724f8 | 3360 3360 |
| 18049 | 18049 | b6f60 | 3360 3360 |
| 18050 | 18050 | 06d39 | 3360 3360 |
| 18051 | 18051 | c2b64 | 3360 3360 |
| 18052 | 18052 | 8b0bf | 3360 3360 |
| 18053 | 18053 | 01e8a | 3360 3360 |
| 18054 | 18054 | 564d4 | 3360 3360 |
| 18055 | 18055 | 2aa57 | 3360 3360 |
| 18056 | 18056 | 99464 | 3360 3360 |
| 18057 | 18057 | 425d7 | 3360 3360 |
| 18058 | 18058 | 762c9 | 3360 3360 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)