This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15247 | 15247 | ec3ac | 16 16 |
| 15248 | 15248 | f5427 | 16 16 |
| 15249 | 15249 | 59d75 | 16 16 |
| 15250 | 15250 | 3502d | 16 16 |
| 15251 | 15251 | 4c549 | 16 16 |
| 15252 | 15252 | b07dd | 16 16 |
| 15253 | 15253 | 7e7c6 | 16 16 |
| 15254 | 15254 | a3ba6 | 16 16 |
| 15255 | 15255 | db9ea | 16 16 |
| 15256 | 15256 | 4071f | 16 16 |
| 15257 | 15257 | 8751c | 16 16 |
| 15258 | 15258 | 6ff25 | 16 16 |
| 15259 | 15259 | cc9e8 | 16 16 |
| 15260 | 15260 | 2809f | 16 16 |
| 15261 | 15261 | a65b8 | 16 16 |
| 15262 | 15262 | d59da | 16 16 |
| 15263 | 15263 | a34e7 | 16 16 |
| 15264 | 15264 | fa092 | 16 16 |
| 15265 | 15265 | d98fb | 16 16 |
| 15266 | 15266 | a9339 | 16 16 |
| 15267 | 15267 | 567c6 | 16 16 |
| 15268 | 15268 | 7a19b | 16 16 |
| 15269 | 15269 | 56e9b | 16 16 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)