This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7260 | 7260 | ec3ac | 1620 1620 |
| 7261 | 7261 | 4de4f | 1620 1620 |
| 7262 | 7262 | 0d60c | 1620 1620 |
| 7263 | 7263 | 5e075 | 1620 1620 |
| 7264 | 7264 | 59d75 | 1620 1620 |
| 7265 | 7265 | e6200 | 1620 1620 |
| 7266 | 7266 | b1201 | 1620 1620 |
| 7267 | 7267 | 902e5 | 1620 1620 |
| 7268 | 7268 | 03f36 | 1620 1620 |
| 7269 | 7269 | cf7f4 | 1620 1620 |
| 7270 | 7270 | a9066 | 1620 1620 |
| 7271 | 7271 | d976f | 1620 1620 |
| 7272 | 7272 | d7035 | 1620 1620 |
| 7273 | 7273 | e31e2 | 1620 1620 |
| 7274 | 7274 | a4c1d | 1620 1620 |
| 7275 | 7275 | 46194 | 1620 1620 |
| 7276 | 7276 | d8324 | 1620 1620 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)