This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2344 | 2344 | d5b86 | 1211 1211 |
| 2583 | 2583 | d5b86 | 1205 1205 |
| 2649 | 2649 | d5b86 | 1147 1147 |
| 2946 | 2946 | d5b86 | 1193 1193 |
| 2958 | 2958 | d5b86 | 1199 1199 |
| 8795 | 8795 | d5b86 | 1215 1215 |
| 8861 | 8861 | d5b86 | 1218 1218 |
| 8994 | 8994 | d5b86 | 1209 1209 |
| 9011 | 9011 | d5b86 | 1217 1217 |
| 9177 | 9177 | d5b86 | 1197 1197 |
| 9202 | 9202 | d5b86 | 1203 1203 |
| 9462 | 9462 | d5b86 | 1151 1151 |
| 35467 | 35467 | d5b86 | 1213 1213 |
| 35495 | 35495 | d5b86 | 1207 1207 |
| 35509 | 35509 | d5b86 | 1214 1214 |
| 35535 | 35535 | d5b86 | 1206 1206 |
| 35556 | 35556 | d5b86 | 1212 1212 |
| 35571 | 35571 | d5b86 | 1208 1208 |
| 35672 | 35672 | d5b86 | 1202 1202 |
| 35700 | 35700 | d5b86 | 1196 1196 |
| 35743 | 35743 | d5b86 | 1148 1148 |
| 35811 | 35811 | d5b86 | 1201 1201 |
| 35868 | 35868 | d5b86 | 1150 1150 |
| 35890 | 35890 | d5b86 | 1195 1195 |
| 35907 | 35907 | d5b86 | 1194 1194 |
| 35932 | 35932 | d5b86 | 1200 1200 |
| 35947 | 35947 | d5b86 | 1149 1149 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)