This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5507 | 5507 | cc5ed | 2744 2744 |
| 5508 | 5508 | 3fb0e | 2744 2744 |
| 5509 | 5509 | e6200 | 2744 2744 |
| 5510 | 5510 | b1201 | 2744 2744 |
| 5511 | 5511 | 902e5 | 2744 2744 |
| 5512 | 5512 | 74b62 | 2744 2744 |
| 5513 | 5513 | db8b3 | 2744 2744 |
| 5514 | 5514 | 2113e | 2744 2744 |
| 5515 | 5515 | 1e955 | 2744 2744 |
| 5516 | 5516 | 0ce79 | 2744 2744 |
| 5517 | 5517 | 22cc9 | 2744 2744 |
| 5518 | 5518 | 415bf | 2744 2744 |
| 5519 | 5519 | d14f5 | 2744 2744 |
| 5520 | 5520 | 0f722 | 2744 2744 |
| 5521 | 5521 | 984e7 | 2744 2744 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)