This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5911 | 5911 | cc5ed | 2505 2505 |
| 5912 | 5912 | d6ade | 2505 2505 |
| 5913 | 5913 | 8e7b3 | 2505 2505 |
| 5914 | 5914 | 313af | 2505 2505 |
| 5915 | 5915 | ebe26 | 2505 2505 |
| 5916 | 5916 | a0f55 | 2505 2505 |
| 5917 | 5917 | cbcce | 2505 2505 |
| 5918 | 5918 | 1073c | 2505 2505 |
| 5919 | 5919 | 371f0 | 2505 2505 |
| 5920 | 5920 | e6200 | 2505 2505 |
| 5921 | 5921 | b1201 | 2505 2505 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)