This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23751 | 23751 | ebcbb | 3315 3315 |
| 23752 | 23752 | 7b150 | 3315 3315 |
| 23753 | 23753 | 5e075 | 3315 3315 |
| 23754 | 23754 | 59d75 | 3315 3315 |
| 23755 | 23755 | e6200 | 3315 3315 |
| 23756 | 23756 | b1201 | 3315 3315 |
| 23757 | 23757 | 8a7ee | 3315 3315 |
| 23758 | 23758 | 862ed | 3315 3315 |
| 23759 | 23759 | ebf60 | 3315 3315 |
| 23760 | 23760 | 18a64 | 3315 3315 |
| 23761 | 23761 | d5ec6 | 3315 3315 |
| 23762 | 23762 | 66f82 | 3315 3315 |
| 23763 | 23763 | f788a | 3315 3315 |
| 23764 | 23764 | 7c38f | 3315 3315 |
| 23765 | 23765 | a2d21 | 3315 3315 |
| 23766 | 23766 | a1307 | 3315 3315 |
| 23767 | 23767 | 809af | 3315 3315 |
| 23768 | 23768 | abb72 | 3315 3315 |
| 23769 | 23769 | 93975 | 3315 3315 |
| 23770 | 23770 | 27369 | 3315 3315 |
| 23771 | 23771 | 37724 | 3315 3315 |
| 23772 | 23772 | e128e | 3315 3315 |
| 23773 | 23773 | 80def | 3315 3315 |
| 23774 | 23774 | 9c206 | 3315 3315 |
| 23775 | 23775 | 7c580 | 3315 3315 |
| 23776 | 23776 | 724f8 | 3315 3315 |
| 23777 | 23777 | b6f60 | 3315 3315 |
| 23778 | 23778 | 6d811 | 3315 3315 |
| 23779 | 23779 | 39ce1 | 3315 3315 |
| 23780 | 23780 | 8b0bf | 3315 3315 |
| 23781 | 23781 | 01e8a | 3315 3315 |
| 23782 | 23782 | 2aa57 | 3315 3315 |
| 23783 | 23783 | 425d7 | 3315 3315 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)