This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17755 | 17755 | f678f | 3340 3340 |
| 17756 | 17756 | 371f0 | 3340 3340 |
| 17757 | 17757 | 5e075 | 3340 3340 |
| 17758 | 17758 | 59d75 | 3340 3340 |
| 17759 | 17759 | e6200 | 3340 3340 |
| 17760 | 17760 | b1201 | 3340 3340 |
| 17761 | 17761 | a50f7 | 3340 3340 |
| 17762 | 17762 | d5ec6 | 3340 3340 |
| 17763 | 17763 | d3559 | 3340 3340 |
| 17764 | 17764 | 649a5 | 3340 3340 |
| 17765 | 17765 | 8a7eb | 3340 3340 |
| 17766 | 17766 | 18a11 | 3340 3340 |
| 17767 | 17767 | 03778 | 3340 3340 |
| 17768 | 17768 | a1f8b | 3340 3340 |
| 17769 | 17769 | 37724 | 3340 3340 |
| 17770 | 17770 | 32bde | 3340 3340 |
| 17771 | 17771 | 06ae5 | 3340 3340 |
| 17772 | 17772 | 710d1 | 3340 3340 |
| 17773 | 17773 | 943de | 3340 3340 |
| 17774 | 17774 | 8d650 | 3340 3340 |
| 17775 | 17775 | fa448 | 3340 3340 |
| 17776 | 17776 | e1dcf | 3340 3340 |
| 17777 | 17777 | f58f7 | 3340 3340 |
| 17778 | 17778 | 6e6b8 | 3340 3340 |
| 17779 | 17779 | e737a | 3340 3340 |
| 17780 | 17780 | e7176 | 3340 3340 |
| 17781 | 17781 | 376eb | 3340 3340 |
| 17782 | 17782 | 2ed38 | 3340 3340 |
| 17783 | 17783 | 60bee | 3340 3340 |
| 17784 | 17784 | 962c9 | 3340 3340 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)