This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6655 | 6655 | b8c83 | 2808 2808 |
| 6656 | 6656 | 20711 | 2808 2808 |
| 6657 | 6657 | 371f0 | 2808 2808 |
| 6658 | 6658 | 5e075 | 2808 2808 |
| 6659 | 6659 | 59d75 | 2808 2808 |
| 6660 | 6660 | e6200 | 2808 2808 |
| 6661 | 6661 | b1201 | 2808 2808 |
| 6662 | 6662 | 902e5 | 2808 2808 |
| 6663 | 6663 | ddd45 | 2808 2808 |
| 6664 | 6664 | 64bc4 | 2808 2808 |
| 6665 | 6665 | 1c5f0 | 2808 2808 |
| 6666 | 6666 | 100e0 | 2808 2808 |
| 6667 | 6667 | 7c38f | 2808 2808 |
| 6668 | 6668 | 809af | 2808 2808 |
| 6669 | 6669 | abb72 | 2808 2808 |
| 6670 | 6670 | 2ce65 | 2808 2808 |
| 6671 | 6671 | 14760 | 2808 2808 |
| 6672 | 6672 | eb152 | 2808 2808 |
| 6673 | 6673 | 3fef5 | 2808 2808 |
| 6674 | 6674 | e128e | 2808 2808 |
| 6675 | 6675 | 302cc | 2808 2808 |
| 6676 | 6676 | 35dce | 2808 2808 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)