This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30235 | 30235 | cc5ed | 3227 3227 |
| 30236 | 30236 | d6ade | 3227 3227 |
| 30237 | 30237 | 8e7b3 | 3227 3227 |
| 30238 | 30238 | d1b15 | 3227 3227 |
| 30239 | 30239 | 5ad28 | 3227 3227 |
| 30240 | 30240 | d4179 | 3227 3227 |
| 30241 | 30241 | 313af | 3227 3227 |
| 30242 | 30242 | ebe26 | 3227 3227 |
| 30243 | 30243 | fbbdb | 3227 3227 |
| 30244 | 30244 | a0f55 | 3227 3227 |
| 30245 | 30245 | 7b150 | 3227 3227 |
| 30246 | 30246 | e6200 | 3227 3227 |
| 30247 | 30247 | 3502d | 3227 3227 |
| 30248 | 30248 | b1201 | 3227 3227 |
| 30249 | 30249 | 04629 | 3227 3227 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)