This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2343 | 2343 | 24da8 | 1211 1211 |
| 2582 | 2582 | 24da8 | 1205 1205 |
| 2648 | 2648 | 24da8 | 1147 1147 |
| 2945 | 2945 | 24da8 | 1193 1193 |
| 2957 | 2957 | 24da8 | 1199 1199 |
| 8794 | 8794 | 24da8 | 1215 1215 |
| 8860 | 8860 | 24da8 | 1218 1218 |
| 8993 | 8993 | 24da8 | 1209 1209 |
| 9010 | 9010 | 24da8 | 1217 1217 |
| 9176 | 9176 | 24da8 | 1197 1197 |
| 9201 | 9201 | 24da8 | 1203 1203 |
| 9461 | 9461 | 24da8 | 1151 1151 |
| 35466 | 35466 | 24da8 | 1213 1213 |
| 35494 | 35494 | 24da8 | 1207 1207 |
| 35508 | 35508 | 24da8 | 1214 1214 |
| 35534 | 35534 | 24da8 | 1206 1206 |
| 35555 | 35555 | 24da8 | 1212 1212 |
| 35570 | 35570 | 24da8 | 1208 1208 |
| 35671 | 35671 | 24da8 | 1202 1202 |
| 35699 | 35699 | 24da8 | 1196 1196 |
| 35742 | 35742 | 24da8 | 1148 1148 |
| 35810 | 35810 | 24da8 | 1201 1201 |
| 35867 | 35867 | 24da8 | 1150 1150 |
| 35889 | 35889 | 24da8 | 1195 1195 |
| 35906 | 35906 | 24da8 | 1194 1194 |
| 35931 | 35931 | 24da8 | 1200 1200 |
| 35946 | 35946 | 24da8 | 1149 1149 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)