This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5764 | 5764 | cc5ed | 1257 1257 |
| 5765 | 5765 | 9f427 | 1257 1257 |
| 5766 | 5766 | 0d5db | 1257 1257 |
| 5767 | 5767 | ca320 | 1257 1257 |
| 5768 | 5768 | 38023 | 1257 1257 |
| 5769 | 5769 | 6623a | 1257 1257 |
| 5770 | 5770 | 8947c | 1257 1257 |
| 5771 | 5771 | d1dcd | 1257 1257 |
| 5772 | 5772 | 6b9d5 | 1257 1257 |
| 5773 | 5773 | 38933 | 1257 1257 |
| 5774 | 5774 | 58f61 | 1257 1257 |
| 5775 | 5775 | 7603f | 1257 1257 |
| 5776 | 5776 | 72024 | 1257 1257 |
| 5777 | 5777 | 39806 | 1257 1257 |
| 5778 | 5778 | 371f0 | 1257 1257 |
| 5779 | 5779 | e6200 | 1257 1257 |
| 5780 | 5780 | b1201 | 1257 1257 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)