This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2347 | 2347 | aa5af | 1211 1211 |
| 2586 | 2586 | aa5af | 1205 1205 |
| 2652 | 2652 | aa5af | 1147 1147 |
| 2949 | 2949 | aa5af | 1193 1193 |
| 2961 | 2961 | aa5af | 1199 1199 |
| 9014 | 9014 | aa5af | 1217 1217 |
| 35470 | 35470 | aa5af | 1213 1213 |
| 35498 | 35498 | aa5af | 1207 1207 |
| 35512 | 35512 | aa5af | 1214 1214 |
| 35538 | 35538 | aa5af | 1206 1206 |
| 35559 | 35559 | aa5af | 1212 1212 |
| 35574 | 35574 | aa5af | 1208 1208 |
| 35675 | 35675 | aa5af | 1202 1202 |
| 35703 | 35703 | aa5af | 1196 1196 |
| 35746 | 35746 | aa5af | 1148 1148 |
| 35814 | 35814 | aa5af | 1201 1201 |
| 35871 | 35871 | aa5af | 1150 1150 |
| 35893 | 35893 | aa5af | 1195 1195 |
| 35910 | 35910 | aa5af | 1194 1194 |
| 35935 | 35935 | aa5af | 1200 1200 |
| 35950 | 35950 | aa5af | 1149 1149 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)